Forum Discussion
Solved
Parallelperiod DAX issue
Hello Power BI Community! I am new to Power BI and currently facing an issue with parallelperiod DAX function. Hope someone in the community has an answer to this! I build a power BI to anal...
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 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
