Dax Measure

[BigBadBob]

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 upload

Requirement: A measure to show the difference between

• A = ‘FACT’[Date Due] (calculated Column)
• B = Selected Date (Measures table) driven by a slicer

If the answer is <0 give 0, if not give A-B

Thanks All

[v-deddai1-msft]

Hi @BigBadBob ,

Would you please inform us more detailed information( your  data(by OneDrive for Business)) if possible? Then we will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.

Best Regards,

Dedmon Dai

[Greg_Deckler · Accepted solution]

@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)

[aj1973]

Hi,

You cannot upload or attach a PIBX file in here, you need to provide a link where to find it, like google drive or dropbox.