DAX Fridays! #161:FIRSTNONBLANK value of a measure

preview_player
Показать описание
In today's video I will show you how to get the top value of a measure so we can crack the billionaire's algorithm.

Happy Friday!

SUBSCRIBE to learn more about Power and Excel BI!

☼☼☼☼☼☼☼☼☼☼

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:

☼☼☼☼☼☼☼☼☼☼

ABOUT CURBAL:

▼▼▼▼▼▼▼▼▼▼

If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:

▲▲▲▲▲▲▲▲▲▲

Our PLAYLISTS:

************

************

QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Twitter ► @curbalen, @ruthpozuelo

#daxfridays #curbal #SUBSCRIBE
  1. Curbal
  2. Power bi
  3. powerbi
  4. Curbal
  5. Curbal.com
  6. DAX Fridays
Рекомендации по теме
DAX Fridays! #161:FIRSTNONBLANK 0:07:53

DAX Fridays! #161:FIRSTNONBLANK value of a measure

FIRSTNONBLANK, LASTNONBLANK, FIRSTNONBLANKVALUE, 0:03:08

FIRSTNONBLANK, LASTNONBLANK, FIRSTNONBLANKVALUE, LASTNONBLANKVALUE - DAX Guide

DAX Fridays! #164: 0:10:04

DAX Fridays! #164: This you need to know about FIRSTNONBLANK and FIRSTNONBLANKVALUE

FIRSTNONBLANK DAX Function 0:04:44

FIRSTNONBLANK DAX Function in Power BI – Simple Example | Get First Value in a Column

firstnonblank dax example 0:02:07

firstnonblank dax example in power bi | firstnonblank in dax

DACODAX - LASTNONBLANK 0:08:30

DACODAX - LASTNONBLANK & FIRSTNONBLANK

DAX Fridays! #163: 0:08:12

DAX Fridays! #163: Best practices when using error functions in DAX

DAX Functions - 0:06:20

DAX Functions - FirstNonBlankValue and LastNonBlankValue in Power BI

DAX Fridays #156: 0:04:17

DAX Fridays #156: How unsensitive of DAX!!!

FirstNonBlank vs FirstNonBlankValue 0:04:55

FirstNonBlank vs FirstNonBlankValue DAX in Power BI TAIK18 (6-43) Power BI

FirstNonBlank() Vs LastNonBlank 0:06:12

FirstNonBlank() Vs LastNonBlank () DAX Functions | DAX Sundays | DAX Tutorial | BI Consulting Pro

Firstnonblank function in 0:05:43

Firstnonblank function in Power BI - 35 (Power BI Training)

DAX Fridays 160: 0:06:06

DAX Fridays 160: Random SAMPLE using DAX

Avoid pitfalls when 0:17:51

Avoid pitfalls when using LASTNONBLANKVALUE and LASTNONBLANK functions - leads to incorrect results

DAX Fridays! #166: 0:10:52

DAX Fridays! #166: Compare spread after the first 100 cases | Recreating the Financial Times Graph

Using LASTNONBLANK For 0:07:04

Using LASTNONBLANK For Dynamic Sales Insights In Power BI - DAX Function Deep Dive [2022 Update]

Get first non 0:01:02

Get first non blank value in a list

Optimizing LASTNONBLANK and 0:12:28

Optimizing LASTNONBLANK and LASTNONBLANKVALUE calculations

DAX Fridays! #171: 0:02:42

DAX Fridays! #171: Distinctcount with blanks

DAX Fridays #159: 0:11:16

DAX Fridays #159: GEOMEAN vs AVERAGE vs MEDIAN - Calculate compounded annual growth rate

DAX Language - 0:04:01

DAX Language - FIRSTNONBLANKVALUE and LASTNONBLANKVALUE Functions in Power BI

Lastnonblank function in 0:05:45

Lastnonblank function in Power BI DAX - 38 (Power BI Training)

LASTNONBLANKVALUE function in 0:05:20

LASTNONBLANKVALUE function in Power BI - 41 (Power BI Training)

DAX Fridays! #150: 0:03:54

DAX Fridays! #150: The 150th DAX Fridays Challenge, can you solve it?

Комментарии
Автор

Hi Ruth, I couldn't find the .PBIX file in the download center. Can you please upload it if possible and find a minute. Advance Thanks.

NaraMeerammaTrust
Автор

Super Ruth. I really like it. As usual you always do very useful videos.

NaraMeerammaTrust
Автор

I understand I am asking something which not related to this topic. I want to understand how can I work with multiple fact tables... I read something about linkage table but can you explain me how does it work? Would it not affect filters? Do you have any video on this?

madiakns
Автор

That's really useful and makes report distinctive

vida
Автор

I like how each page is similar but answers one question. On iOS, an iPad3, can’t get the right click to work to drill through for a country. Maybe there’s a trick for that?

MilhouseBS
Автор

OK. So what Top Gender 2 expression makes is to create a filtered table where all rows are "Male" and select "Male" because all of the rows are "Male"...
So where is the blank row?
It's hard to me to understand. :-(( ¿¿???
Thanks a lot Ruth!!!
Josep.

josepromero
Автор

Wow awesome report! Nice graphs and sweet display of the visuals. But pleaae, omit my name at the Brazil's list, ok?

There is a custom visual called "enlighten data story" available at the mktplace that kinda do the same approach with less dax code.
(Well maybe the point is learning dax ? )

Cheers and have a great weekend.

brunof.s.