topic Re: previous week in DAX Commands and Tips

previous week

Anonymous — Thu, 18 Aug 2022 08:09:02 GMT

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.

(pic1)

(pic2)

Re: previous week

amitchandak — Thu, 18 Aug 2022 08:27:02 GMT

Anonymous , 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-bd52912a5bd4
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.

Re: previous week

Anonymous — Thu, 18 Aug 2022 10:17:15 GMT

Hi amitchandak ,

It works what I want. Thanks a lot