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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Kim_Sky
Helper II
Helper II

previous week

Hi, 

I would like to create a measure that allowed me to show the previous week value. 

When the user click wk 32, then the graph will shown the current week (wk32) and previous week (wk31) data in a graph. 

 

the graph is clustered column chart and the xaxis will be category, weekday short; yaxis will be previous week (light colour) and current week (dark colour). 

 

Previous Week = calculate(sum('Flow '[Value]),FILTER(all('Calendar'),'Calendar'[Date]=MAX('Calendar'[Date])-7))

 

current week=sum('Flow'[Value])

The issue that i having now is the pic 1 is under category (for the previous week suppose the sum of pic 2 but just obtain sunday value).  Can anyone help me to change the previous week dax so that the under category can get the sum from monday to sunday. 

 

Thanks for your help. 

Kim_Sky_0-1660809787417.png(pic1)

Kim_Sky_1-1660809802949.png(pic2)

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Kim_Sky , Make sure calendar table is maked as date table and Weekday are coming from calendar table.

 

Try like

 

Previous Week = calculate(sum('Flow '[Value]),Dateadd('Calendar'[Date],-7, Day))

 

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5b...
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@Kim_Sky , Make sure calendar table is maked as date table and Weekday are coming from calendar table.

 

Try like

 

Previous Week = calculate(sum('Flow '[Value]),Dateadd('Calendar'[Date],-7, Day))

 

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5b...
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

Hi @amitchandak ,

 

It works what I want. Thanks a lot

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors