Forum Discussion

Frequent Visitor

3 years ago

Solved

Datediff using allselected and slicer

I have a database that compiles information received from several organization and I have to keep track on how many days has passed since the last submission. I am doing it using this measure: O...

Rafaelhk
3 years ago
amitchandak ,

Thank you for the reply. Although your formula did not work, you pointed me in the right direction.

This is the formular that worked:

Days from last submission = CALCULATE(DATEDIFF(MAX(Submissions[last_submission_date]),Submissions[Overall last submission date], DAY))

amitchandak

Super User

3 years ago

Rafaelhk , The second one needs to be a measure too

Days from last submissoin= DATEDIFF(Max(Submissions[last_submission_date]), Submissions[Overall last submission date], DAY)

sumx(values(Submissions[Organization]) ,calculate(DATEDIFF(Max(Submissions[last_submission_date]), Submissions[Overall last submission date], DAY) ) )

Rafaelhk

Frequent Visitor

3 years ago

amitchandak ,

Thank you for the reply. Although your formula did not work, you pointed me in the right direction.

This is the formular that worked:

Days from last submission = CALCULATE(DATEDIFF(MAX(Submissions[last_submission_date]),Submissions[Overall last submission date], DAY))