Hello forum,
New to PowerPivot and loving it. Glad this forum exists.
I am playing with DAX for the first time and am having an issue doing something that should be easy.
I have the below data, all in the one table, no extra date table.
This is my pivot.
What I need to do is just simply have a measure, which will show me the Growth on previous year.
[Current Year] - [Previous Year] / [Previous Year]
The problem is, I can;t figure out the DAX syntax to get the previous column. I have the columns using "Year", which is a clumn just made from another date column, but using YEAR() to get the year. I have tried using this to get just the previous year sales amount:
-- removed inline image ---
But Year -1 doesn't seem to do it. I get the same figure in each of the Measure columns. Perhaps I need to use ALL() to release other filters? Or do I need a seperate date table for this? Any thoughts appreciated.
New to PowerPivot and loving it. Glad this forum exists.
I am playing with DAX for the first time and am having an issue doing something that should be easy.
I have the below data, all in the one table, no extra date table.
This is my pivot.
What I need to do is just simply have a measure, which will show me the Growth on previous year.
[Current Year] - [Previous Year] / [Previous Year]
The problem is, I can;t figure out the DAX syntax to get the previous column. I have the columns using "Year", which is a clumn just made from another date column, but using YEAR() to get the year. I have tried using this to get just the previous year sales amount:
-- removed inline image ---
But Year -1 doesn't seem to do it. I get the same figure in each of the Measure columns. Perhaps I need to use ALL() to release other filters? Or do I need a seperate date table for this? Any thoughts appreciated.
