Forum Discussion
YOY Date Comparison Help
Hello!
I'm trying to build a YOY comparison, preferably refreshable, comparing last calendar month from both 2022 and 2021, in $$ across 8 different categories. The 2022 data appears correct, but when I put the 2021 info in, it appears to be displaying full totals in every column. See screen shot below--what do I need to do to fix this one?
Anonymous
create a dimension table and put the column into axis field
dim = VAR a=SELECTCOLUMNS(VW_CANCELLATIONS,"rejection description",VW_CANCELLATIONS[Rejection Description (Full)]) VAR b=SELECTCOLUMNS('VW_CANCELLATIONS (2021)',"rejection description",'VW_CANCELLATIONS (2021)'[Rejection Description (Full)]) return DISTINCT(UNION(a,b))
