Forum Discussion
Solved
Dax Measure
I think i am having a really off day today. I can not even see where to upload the PBIX file i have prepared..... Anway, heres the prob and let me know if you would like the pbix file / where to upl...
BigBadBob - If you do not have privileges to attach files, you generally have to use OneDrive, Box or some other file sharing service and post a link.
If I understand the question correctly, should be something like:
Measure = VAR __Diff = ( MAX('FACT'[Date Due]) - SELECTEDVALUE('Table'[Date]) ) * 1. RETURN IF(__Diff < 0, 0, __Diff)
BigBadBob - If you do not have privileges to attach files, you generally have to use OneDrive, Box or some other file sharing service and post a link.
If I understand the question correctly, should be something like:
Measure =
VAR __Diff = ( MAX('FACT'[Date Due]) - SELECTEDVALUE('Table'[Date]) ) * 1.
RETURN
IF(__Diff < 0, 0, __Diff)