Forum Discussion
Monthly Calculation Table
Hi clim2f88j
In order to achieve your goal, you can:
Preparing data in PQ is the first step:
Add a column with the month names2. Add column with concatenating string "issue" to your issues:
after it press "close and apply"
3 . Create a measure to count rows for issues with Dax:ISS_QTY = count('Table'[ Issue ])4. Create Matrix with , months in rows, issues on columns and your measure on values
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi clim2f88j
1 use filter / slicer by year and just select the year you interested to analyse
2. You need to sort months names by column of their number .
Please refer my answer in the linked discussion:
It includes samle file
I hope it helps, Rita
Thank you, this worked...for the most part.
I didn't do step 2 because it was not needed to concatenate the "issues".
Two issues i'm having:
- By doing this, it includes ALL the months/years. How can i select in the table to only show the totals for 2023? (i know i didn't state this in my original post)
- The month collumn is in alphabetical order. Any way to change that to the correct "yearly order"?
Hi clim2f88j
1 use filter / slicer by year and just select the year you interested to analyse
2. You need to sort months names by column of their number .
Please refer my answer in the linked discussion:
It includes samle file
I hope it helps, Rita