Forum Discussion
Parallelperiod DAX issue
Hi hidenseek9,
You can create a quarter calculated column including Q1,Q2,Q3 and Q4.
Then create a measure using the formula.CY-quarter=CALCULATE(SUM(Table[revenue]),ALLEXCEPT(Table, Table[quarter]))
Finally, you can create the difference between 2016 and 2017 year.
Var=CALCULATE(Table[CY-quarter],FILTER(Table,Table[year]=2017))-CALCULATE(Table[CY-quarter],FILTER(Table,Table[year]=2016))
Please try the solution above and check if it works. Please don't hesitate to ask if you have other problems.
Best Regards,
Angelia
Hi hidenseek9,
You can create a quarter calculated column including Q1,Q2,Q3 and Q4.
Then create a measure using the formula.
CY-quarter=CALCULATE(SUM(Table[revenue]),ALLEXCEPT(Table, Table[quarter]))
Finally, you can create the difference between 2016 and 2017 year.
Var=CALCULATE(Table[CY-quarter],FILTER(Table,Table[year]=2017))-CALCULATE(Table[CY-quarter],FILTER(Table,Table[year]=2016))
Please try the solution above and check if it works. Please don't hesitate to ask if you have other problems.
Best Regards,
Angelia
Thank you so much for your advice.
Since I do random LY (month, quarter, ramdomly selected months) comparison,
I did not use the formula suggested.
Instead, I was able to do the comparison by creating a master calendar that has all the dates
from Jan 1 - Dec 31 of all the years in the data and link to the original data source.
Appreciate your quick response and kind support nonetheless!
Hide
Hi hidenseek9,
You have resolved your issue, right? If it is, please mark the helpful reply as answer, so that more people can find workaround form here. Thanks for understanding.Best Regards,
Angelia
