Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
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.
Hi! Assuming you have a robust Date dim table, you can utilize the following links to do your week basewd time intelligence.
Week-Based Time Intelligence in DAX - SQLBI
Week-related calculations – DAX Patterns
Proud to be a Super User! | |