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

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

Reply
Aish
Regular Visitor

LASTNONBLANKVALUE not working where there are mutiple values for the same date

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....

Aish_0-1682991177481.png

 

LASTNONBLANKVALUE (
                'Fact'[DateKey],
                SELECTEDVALUE ('Dimension'[Residential_Status] ))





1 ACCEPTED SOLUTION
wdx223_Daniel
Super User
Super User

LASTNONBLANKVALUE (
                'Fact'[DateKey],
                MAX ('Dimension'[Residential_Status] ))

View solution in original post

3 REPLIES 3
Aish
Regular Visitor

actually ignore me that seems to be working when I have date filter, Thank you so much.

wdx223_Daniel
Super User
Super User

LASTNONBLANKVALUE (
                'Fact'[DateKey],
                MAX ('Dimension'[Residential_Status] ))

I have tried that , but that returns the value alphabetically disregarding the max date 

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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

Top Kudoed Authors