Forum Discussion
Solved
DAX Formula gives error
Dear All, My data table given below. FIN Year Last year and Previous Year are in ine column and trying to get the GR% and below Dax formula made but while adding the measure to Report im getting the...
I tried it in differnt way and got the output as per your expectections. You can also try something like this (I know there might be different ways to achieve).
Create a column
Year_Calc = VALUE(LEFT(Sheet1[FIN Year],4))
Create a measure
Growth% = var YearGrowth= CALCULATE(SUM(Sheet1[Stock Value]),FILTER(ALL(Sheet1),Sheet1[Year_Calc]=MIN(Sheet1[Year_Calc])-1)) return DIVIDE(SUM(Sheet1[Stock Value])-YearGrowth,YearGrowth)*100
I created a dummy column "Year Type" for testing in Matrix
Please correct me if I am missing something.
Regards
Vamsi
Dear Frank,
Yes formula working but when im tring to bring to Matrix outputs are coming same 100%.
I tried it in differnt way and got the output as per your expectections. You can also try something like this (I know there might be different ways to achieve).
Create a column
Year_Calc = VALUE(LEFT(Sheet1[FIN Year],4))
Create a measure
Growth% = var YearGrowth= CALCULATE(SUM(Sheet1[Stock Value]),FILTER(ALL(Sheet1),Sheet1[Year_Calc]=MIN(Sheet1[Year_Calc])-1)) return DIVIDE(SUM(Sheet1[Stock Value])-YearGrowth,YearGrowth)*100
I created a dummy column "Year Type" for testing in Matrix
Please correct me if I am missing something.
Regards
Vamsi