Forum Discussion
afaro
Helper III
Helper IIIHow to find the change between any two rows dynamically?
I have weekly data for each product. I want to find out the change between any two weeks of given product given I have a timestamp column specifying all relevant date/time info. How do I do this?
Thank you in advance.
2 Replies
- audreygerred
Super User
Hi! Assuming you have a robust Date dim table, you can utilize the following links to do your week basewd time intelligence.
Hi afaro
Based on your description, you can consider to use datesinperiod() function.
e.g
Measure = CALCULATE ( [Measure], DATESINPERIOD ( calendar[date], MAX ( 'Date'[Date] ), -14, DAY ) )You can refer to the link about the function.
DATESINPERIOD function (DAX) - DAX | Microsoft Learn
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
DATESINPERIOD
