Forum Discussion

charlie7491's avatar
charlie7491
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago
Solved

Trying to get the difference between two measure values using DAX

I will like to get the difference between two measure values using DAX AADPMAU_Increase = [AADPMAU_End] - [AADPMAU_Start] But when I do the subtraction, I am getting 0 I have tried different thing...
  • charlie7491's avatar
    charlie7491
    4 years ago

    Thanks so much. I have found the solution. I will post it here soon, hopefully

Whitewater100's avatar
Whitewater100
Icon for Solution Sage rankSolution Sage
4 years ago

Hi:

You can try the following. Assuming your date slicer is from date table. 

startdate = FIRSTDATE(Dates[Date])
Enddate = LASTDATE(Dates[Date])
Days Diff = INT([Enddate] - [startdate])
You may need to adjust the table names to match, but this is the jist of it. Hope this helps.
charlie7491's avatar
charlie7491
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago

I need the AADPMAU Increase in the values associated with the date changes (and not the difference in dates)

Do you have any suggestion how I can use your approach to calculate the difference?

  • Whitewater100's avatar
    Whitewater100
    Icon for Solution Sage rankSolution Sage
    4 years ago

    Hi:

    I can check it out but ask for some data , like you are working with. 

    Even if it's excel with made up info it's fine. 

    Thanks..

    • charlie7491's avatar
      charlie7491
      Icon for Microsoft Employee rankMicrosoft Employee
      4 years ago

      I have the sample PBIX file with the problem scenario but I see no way to send that file to you. Do you know how I may be able to send it to you?

      • Whitewater100's avatar
        Whitewater100
        Icon for Solution Sage rankSolution Sage
        4 years ago

        Hi:

        If yu use dropbox or google drive you can upload to those site and grab a link and paste it into your message.

         

        If you want you can send to my email  [email protected]

         

        Thanks.