https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/To-perform-lag-in-DAX-dynamically/m-p/3382670#M157584 <P>Hi Team,&nbsp;&nbsp;</P><P>&nbsp;</P><P>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.<BR />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)&nbsp;<BR /><BR />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.<BR />Please help me.<img /></P> Wed, 16 Aug 2023 11:38:27 GMT Charitha_RK 2023-08-16T11:38:27Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/To-perform-lag-in-DAX-dynamically/m-p/3382670#M157584 <P>Hi Team,&nbsp;&nbsp;</P><P>&nbsp;</P><P>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.<BR />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)&nbsp;<BR /><BR />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.<BR />Please help me.<img /></P> Wed, 16 Aug 2023 11:38:27 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/To-perform-lag-in-DAX-dynamically/m-p/3382670#M157584 Charitha_RK 2023-08-16T11:38:27Z