topic Re: LASTNONBLANKVALUE not working where there are mutiple values for the same date in DAX Commands and Tips

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

Anonymous — Tue, 02 May 2023 01:35:01 GMT

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

LASTNONBLANKVALUE (

'Fact'[DateKey],

SELECTEDVALUE ('Dimension'[Residential_Status] ))

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

wdx223_Daniel — Tue, 02 May 2023 02:01:23 GMT

LASTNONBLANKVALUE (

'Fact'[DateKey],

MAX ('Dimension'[Residential_Status] ))

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

Anonymous — Tue, 02 May 2023 02:04:15 GMT

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

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

Anonymous — Tue, 02 May 2023 02:15:27 GMT

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