Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 activities |
321546 | 1/5/2019 | null |
456878 | 1/7/2019 | null |
321546 | 1/9/2019 | 4 |
456878 | 1/30/2019 | 23 |
So with the information in columns [ID] and [Date], I'd like to create the column [Days between activities]. In the above example the first two rows of table values would be first activities from new clients, thus the values in [Days between activities] being null (because there are no earlier activities).
Any help would be greatly appreciated!
Solved! Go to Solution.
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-wi...
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
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-wi...
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
77 | |
69 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |