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 da...
v-weiyan1-msft's avatar
v-weiyan1-msft
Icon for Community Support rankCommunity 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.