Forum Discussion
Dynamic Last Week Indicator
Hey,
Id like to create a meassure and show it as an indicator for the sales of last week. BUT, what I really want is that the "Last week" is not necessarily 7 days ago. What I need is whenever I use a Week Slicer, the measure always shows me the result one week before the one I selected on the slicer and whenever the Data is not filtered shows me the real last week.
Thank you guys
Hello Anonymous
Because you had a week column in your Calendar table already we are able to just use that. I added a measure to the .pbix.
QA Score Last Week = VAR MaxWeek = CALCULATE(MAX('Calendar'[Week]),QAData) VAR SelectedWeek = SELECTEDVALUE( 'Calendar'[Week],MaxWeek ) RETURN CALCULATE( [QA Score], 'Calendar'[Week] = SelectedWeek-1 )And added it to the table visual in your file then uploaded it here:
https://www.dropbox.com/s/0bdr84qdqz6auyv/QA%20Dashboard.pbix?dl=0
7 Replies
Hello Anonymous ,
You can add a WeekOffset column to your date table that will help.
Week Offset = DATEDIFF( TODAY(), Dates[Date], WEEK )
Then you write a measure, something like this.
Last Week = VAR SelectedWeek = SELECTEDVALUE( Dates[Week Offset], 0 ) RETURN CALCULATE( Sales[Sales Amount], Dates[Week Offset] = SelectedWeek-1 )If no week is selected the VAR SelectedWeek will give 0 and that will get adjusted in the CALCULATE by -1 giving you last week. If you do selected a week the CALCULATE will pull the previous week amount.
Are you adding it as a column in your date table? Are you able to share your .pbix file (uploade it to dropbox or onedrive and post a link)?
Hi,
Share some data and show the expected result.
