Forum Discussion
Julien_F
Helper I
Helper IQUICk 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 ...
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
parry2k
Super User
Super UserJulien_F are you open to share pbix file? Remove any sensitive information before sharing.
amitchandakSuper User
Super UserIn 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
- amitchandak
In case you need 365 days before (All data < date-365, All Data)
On the Fly Change % = Var _last_year= (max('Date'[Date Filer]))-365 Var _This_year=year(max('Date'[Date Filer])) Var _last_year_val= CALCULATE(sum(Sales[Sales Amount]),(Sales[Sales Date])<=_last_year) Var _This_year_val =CALCULATE(sum(Sales[Sales Amount])) return (_This_year_val-_last_year_val)/_last_year_val*100 
Julien_FThx you make my day haha ( didn't know that one ! )
v-chuncz-msftCommunity Support