Forum Discussion

MSW's avatar
MSW
Helper I
4 years ago
Solved

Sequential Calculation Between Date

Hello PBI Community,    I'm stuck on trying to figure out how to make a dax calculation for the following data. I need a calculation that will count sequentially by ID the days between two dates us...
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, MSW ,

    Try it.

    Measure = var _a=CALCULATE(MAX('Table'[Complete Date]),FILTER(ALL('Table'),[ID]=MAX([ID])&& [EQ]<MAX('Table'[EQ])))
return 
IF(MAX('Table'[EQ])=10,DATEDIFF(MAX('Table'[StartDate]),MAX('Table'[Complete Date]),DAY),DATEDIFF(_a,MAX('Table'[Complete Date]),DAY))

    The final show:


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

daXtreme's avatar
daXtreme
Solution Sage
4 years ago

Hi MSW 

 

Sorry but I have some problems to follow what it is you want. Could you please be more specific? Please refer to this article for ideas about how to make your question a good one: How to Get Your Question Answered Quickly (powerbi.com)

 

It's always good to place in here the starting point, the reasoning for achieving the final result and the final result itself. This will immensely increase the chances of addressing your problem.