Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Calculate date difference over time

Hello community I can't calculate a measure that calculates days lost across 2 dates (beginning of the decline and end of the decline).

 

I have a fact table that shows me all the accidents, the date the accident occurred and the dates of sick leave.

 

How can I calculate the days lost?

 

 

 

Thanks for the help.

2 Replies

  • v-weiyan1-msft's avatar
    v-weiyan1-msft
    Community Support
    2 years ago

    Hi Anonymous ,

     

    Based on your description,
    Please try code as below to create a measure.
    My Sample:

    The lost days = DATEDIFF(SELECTEDVALUE('Table'[Inicio]),SELECTEDVALUE('Table'[Fim]),DAY)+1

    Result is as below.

    Please correct me if I misunderstood your needs.

     

    Best Regards,
    Yulia Yan

    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
      2 years ago

      v-weiyan1-msft  Many thanks for the reply.

       

      It's not the solution I want. I intend to know how many lost days I have each month. We have sick leave that lasts for several months. After applying slicers, I want to know how many days were lost each month. There may be casualties that start on the same day.