Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Minimum datediff per unique value

Let's say i've got a couple of relevant columns:    Cases Doc numbers Date last used  A 11 12-12-22 A 22 09-12-22 A 33 01-02-22 B 41 11-12-22 B 54 10-12-22 ...
  • v-jialluo-msft's avatar
    v-jialluo-msft
    3 years ago

    Hi  Anonymous ,

     

    Please follow these steps:
    (1) Create a new measure

     

    DIFF = 
DATEDIFF(CALCULATE(MAX('Table'[Date last used]),FILTER(ALL('Table'),'Table'[Cases] = MAX('Table'[Cases]))),TODAY(),DAY)

     


    (2)Final output

     

     

    Best Regards,
    Gallen Luo
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-jialluo-msft's avatar
v-jialluo-msft
Community Support
3 years ago

Hi  Anonymous ,

 

Please follow these steps:
(1) Create a new measure

 

DIFF = 
DATEDIFF(CALCULATE(MAX('Table'[Date last used]),FILTER(ALL('Table'),'Table'[Cases] = MAX('Table'[Cases]))),TODAY(),DAY)

 


(2)Final output

 

 

Best Regards,
Gallen Luo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

You are the best! Added it as a meassure and used the meassure to calculate if a certain case is longer inactive than I want it to be and now it works! Thank you very much and have a nice day!