Forum Discussion

BigBadBob's avatar
BigBadBob
Helper I
6 years ago
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...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    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)
v-deddai1-msft's avatar
v-deddai1-msft
Community Support
6 years ago

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