Forum Discussion
Julien_F
Helper I
7 years agoQUICk MEASURE FAILED
Hello, WHat is wrong here Gross YoY% = IF( ISFILTERED('BNP_FINANCIAL_NIELSEN_OUTPUT'[PUB_DATE]), ERROR("Time intelligence quick measures can only be grouped or filtered by the ...
- 7 years ago
In case you need this year vs Last year
On the Fly Change % = Var _last_year= year(max('Date'[Date Filer]))-1 Var _This_year=year(max('Date'[Date Filer])) Var _last_year_val= CALCULATE(sum(Sales[Sales Amount]),YEAR(Sales[Sales Date])=_last_year) Var _This_year_val =CALCULATE(sum(Sales[Sales Amount]),YEAR(Sales[Sales Date])=_This_year) return (_This_year_val-_last_year_val)/_last_year_val*100
Julien_F
Helper I
7 years agoThx you make my day haha ( didn't know that one ! )
v-chuncz-msft
Community Support
6 years ago