Hi Team,
I need to calculate the number of days between the current date and the previous row date or create a lag column which shifts the dates only for the selected subset/group selected on the slicer.
Suppose highlighted orange box is my data, I want the results as shown beside the table. Based on the slicers selected I want the number of days bewteen the events(A,B) or subevents(AA,AB,BA,BB)
Ex: In the group, if event A has occured on 01/01/2023 and next time event A has occured on 01/03/2023, I want the number of days difference as 2 days, This measure/calculated column should work dynamically for any slicer group.
Please help me.
Helpful resources
Power BI Monthly Update - July 2025
Check out the July 2025 Power BI update to learn about new features.
Join our Fabric User Panel
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Fabric Community Update - June 2025
Find out what's new and trending in the Fabric community.
