Forum Discussion
Assistance Required with Relative Date measures for custom dataset
The PBI report that I'm working with doesn't have a date table to calculate measures for relative date periods. Instead, I have a dataset something similar to the first screenshot below. On the report layout, there would be only one slicer to select 'Week Starting Date'. The second screenshot below is how the tabular report layout looks like. With this dataset structure, I'm struggling to calculate the measures (displayed in the second screenshot) for the current and prior years. Your assistance in this matter would be greatly appreciated.
Dataset Struture:
Report Layout: [Prior year realtive measures must have same cut off point as current year]
4 Replies
- lbendlin
Super User
"as I believe that this would be a good learning moment for me to calculate relative time period mesures without a date table"
I would respectfully disagree. Doing time intelligence calculations without a calendar table is cumbersome, risky, and not something you should do if you want to learn Power BI.
- Ashish_Mathur
Hi,
Creating a Date table with columns for Year, Month name, Month number and Week strt date would be absolutely imperative to solving the question.
