Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
artlearning
Regular Visitor

Firstnonblank not working without month month column

Hello everyone - I'm trying to get the very first month name where I have a transaction. I tried to use Firstnonblank but it's not working as expected. Here's my dataset

 

CustomerAugust, 2022September, 2022November, 2022December 2022
A11  
B  55

 

I tried this expression 

 

Cust Firt Order:=FIRSTNONBLANK(Sales[Fiscal Month],[Lics]>0)

 

But is not working for all cases

 

CustomerCust First Order
AAugust, 2022
BDecember, 2022

 

For customer A, I get the correct date since the first transaction ocurred in August, but for customer B, I'm getting the December date when I should get November.

 

Appreciate your help!

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@artlearning , Make sure you are using a date table , use date in place of month name, month name are not sortable , Create date from Month Year

 

calculate(firstnonblankvalues(Date[Date], [Value Measure]) )

 

or

 

calculate(firstnonblankvalues(Date[Date] ), [Value Measure]), filter( allselected(Table), Table[Customer] = max(Table[Customer]) ) )

 

 

Also, you can explore the Index function

 

Power BI Index function: Top/Bottom Performer by name and value- https://youtu.be/HPhzzCwe10U

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@artlearning , Make sure you are using a date table , use date in place of month name, month name are not sortable , Create date from Month Year

 

calculate(firstnonblankvalues(Date[Date], [Value Measure]) )

 

or

 

calculate(firstnonblankvalues(Date[Date] ), [Value Measure]), filter( allselected(Table), Table[Customer] = max(Table[Customer]) ) )

 

 

Also, you can explore the Index function

 

Power BI Index function: Top/Bottom Performer by name and value- https://youtu.be/HPhzzCwe10U

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors