Forum Discussion

Rafaelhk's avatar
Rafaelhk
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's avatar
    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's avatar
amitchandak
Icon for Super User rankSuper 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's avatar
    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))