Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Calculate time between values

Hi all,    I need to create a columnt that indicates how many days have passed between last two activities with the same client. Here's an example:    ID Date (mm/dd/yyyy) Days between activ...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

Try like

datediff(table[date],MINX(filter(Table,Table[Date]>EARLIER(Table[Date]) 
&& Table[Id]= EARLIER(Table[Id])),Table[Date]),DAY)

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners/ba-p/890814
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Dear amitchandak , 

     

    thank you so very much for your assistance. You are a true Power BI hero and wizard! It worked on the first try, simple and efficient. I salute you! 

     

    Kind regards, 

    Heidi