Forum Discussion

Frequent Visitor

6 years ago

getting previous week value

Could someone tell me what is wrong with my measure? measure = var previousweek= if( MOD(SELECTEDVALUE('table'[yearweek]),100)=1, SELECTEDVALUE('table'[yearweek])-49, SELECTEDVALUE('table'...

Need Help

VladMatao

Frequent Visitor

6 years ago

v-kelly-msft amitchandak

I think this one doesn't work because the "cat_type" and "category" will change, and if I want to show it for certain category types for example will give me the wrong value. I managed to do it with a column:

lastweekvalue = CALCULATE(SUM('table'[value]),FILTER('table',EARLIER('table'[category])='table'[category] && EARLIER('table'[KPI_type])='table'[KPI_type] && EARLIER('node'[cat_type])='table'[cat_type] && EARLIER('table'[year week])='table'[year week]+if(MOD('table'[year week],100)=52,49,1)))

But I would still like to know if this is possible with a measure