Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

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:

 

Dataset Structure.png

 

 

 

 

 

 

 

 

 

 

 

Report Layout:  [Prior year realtive measures must have same cut off point as current year]

Report Layout with Slicer.png

 

4 REPLIES 4
Anonymous
Not applicable

Could someone please advise? 

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. 


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Anonymous
Not applicable

I understand. Unfortunately, that is the way the data set is. How can I calculate the measures I need without having to use Time Intelligence functions? 

lbendlin
Super User
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.

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.