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 ...
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
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
Thanks so much for your help!! That exactly what I needed :)