Forum Discussion
LAG / LEAD SQL Alternative in power bi. Partitioning.
Hi All, I've got a list of CustomerIDs and datetimes and a 'status' of either 1,2,3,4/5. e.g. I would like to get a date range by getting and EndDateTime. This is what i have: CustomerID...
Hi Anonymous ,
Please try:
EndDateTime = MINX(FILTER('Table',[CustomerID]=EARLIER('Table'[CustomerID]) && [DateTime]>EARLIER('Table'[DateTime])),[DateTime])If it's not you wanted, please share more detail information to help us clarify your scenario.
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
Please try:
EndDateTime = MINX(FILTER('Table',[CustomerID]=EARLIER('Table'[CustomerID]) && [DateTime]>EARLIER('Table'[DateTime])),[DateTime])
If it's not you wanted, please share more detail information to help us clarify your scenario.
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.