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?