Forum Discussion
Year over year comparison
Hi clairethnguyen,
For your desired output, it seems that you want to get the output like this.
If you want to get the output above, please follow the steps below.
1. Unpivot Has curriculum map and use of results columns in Query Editor.
2. Create the measures below.
yes = CALCULATE(COUNTROWS('Table2'),FILTER('Table2','Table2'[Value]="yes")) totalrows for each year = CALCULATE(COUNT(Table2[Program name]),ALLEXCEPT(Table2,Table2[Year])) percent = [yes]/ [totalrows for each year]3. Create the bar chart.
More details, you could refer to the attachment.
Best Regards,
Cherry
Hi clairethnguyen,
For your desired output, it seems that you want to get the output like this.
If you want to get the output above, please follow the steps below.
1. Unpivot Has curriculum map and use of results columns in Query Editor.
2. Create the measures below.
yes = CALCULATE(COUNTROWS('Table2'),FILTER('Table2','Table2'[Value]="yes"))
totalrows for each year = CALCULATE(COUNT(Table2[Program name]),ALLEXCEPT(Table2,Table2[Year]))
percent = [yes]/ [totalrows for each year]
3. Create the bar chart.
More details, you could refer to the attachment.
Best Regards,
Cherry
Hi Cherry v-piga-msft
Thanks a bunch for your help. This is what I want. I just dragged "Attribute" into the axis. I guess now I need to figure out how to make it work for my complete data set.