The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Customer | August, 2022 | September, 2022 | November, 2022 | December 2022 |
A | 1 | 1 | ||
B | 5 | 5 |
I tried this expression
Cust Firt Order:=FIRSTNONBLANK(Sales[Fiscal Month],[Lics]>0)
But is not working for all cases
Customer | Cust First Order |
A | August, 2022 |
B | December, 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!
Solved! Go to Solution.
@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
@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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
18 | |
18 | |
17 | |
15 | |
13 |
User | Count |
---|---|
36 | |
35 | |
19 | |
18 | |
18 |