Forum Discussion
Previous Period Calculation
Hello guys, I need some help in calculating the previous period based on current year selection. We are showing the data in a bar chart, which will only have current year data in months. For ...
Hi sudhakar111
Do you have a separate date table? DAX functions like PARALLELPERIOD and SAMEPERIODLASTYEAR prefer to work with date columns in a separate date table.
Hi Phil,
I do have a separate date table. Using any of Parallelperiod or Sameperiodlastyear gives me the values for the whole month of march for last year instead of month to date lat year.