Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi all, i was wondering if anyone knows how to make LASTNONBLANK dax funtion to work when there are mutiple values for the same date or datekey ? below is my table and the dax I used and atm when I use LASTNOBLANK in a calculatetable I get blank values for this ID as it doesn't know which one to pick ! I want it to just pick one randomly....
Solved! Go to Solution.
actually ignore me that seems to be working when I have date filter, Thank you so much.
I have tried that , but that returns the value alphabetically disregarding the max date
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
31 | |
15 | |
14 | |
13 | |
9 |