Forum Discussion

kballar1's avatar
kballar1
Helper I
2 years ago
Solved

SUMX Help

  I created a measure using SUMX to get the number of days between two dates so that I could see how many days it takes an account manager to approve something once it's submitted for approval...
DAX SUMX
“DAX"
  • PijushRoy's avatar
    PijushRoy
    2 years ago

    Hi kballar1 

    In your data screenshot, the Physical Date and Price Approved Date are not in Date format. Please make both dates as Date format.
    Use Power Query to correct your data datatype


    Then use the measure

    Measure = DATEDIFF(SELECTEDVALUE('Table (2)'[Physical Date]),SELECTEDVALUE('Table (2)'[Price Approved]),DAY)

     

     

     



    You will find all date diff are correct

    If solved your requirement, please mark this answer as SOLUTION.

    Thanks
    Pijush

kballar1's avatar
kballar1
Helper I
2 years ago

 Hi,

I tried that but as you can see, it works one some but not the other. There are not 48 days between 12/21/2023-1/02/2024. How do I fix this? 

PijushRoy's avatar
PijushRoy
Community Champion
2 years ago

Hi kballar1 

In your data screenshot, the Physical Date and Price Approved Date are not in Date format. Please make both dates as Date format.
Use Power Query to correct your data datatype


Then use the measure

Measure = DATEDIFF(SELECTEDVALUE('Table (2)'[Physical Date]),SELECTEDVALUE('Table (2)'[Price Approved]),DAY)

 

 

 



You will find all date diff are correct

If solved your requirement, please mark this answer as SOLUTION.

Thanks
Pijush

  • kballar1's avatar
    kballar1
    Helper I
    2 years ago

    It was already marked as date I was just presenting the data in a table visual. But I tried the code you suggested and it worked. Thank you!