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

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)

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    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)
  • aj1973's avatar
    aj1973
    Community Champion
    6 years ago

    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. 

  • 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