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
Hi clim2f88j ,
I am giving below the steps to achieve this from Power Query editor
1. Set your Date column with Date Data Type. If your column creates an issue, split the column into Month, Date and Year and create a new date column using the below functions
#date([Year],[Month],[Day])
2. Create a new column by concatenating Issue with A/B/C. You end result will be Issue A, Issue B, Issue C
Text.Combine({" Issue", [#" Issue "]}), type text)
3. Create a column for Month Name from the Parse option in Add Column
4. Create a measure as below
4. Drag the New Month Name Column into the Pivot row, Issue Name to the Pivot Column and No of Issues to Value
5. Sort the Month Name using Month Number by using the "Sort by Column" option
The Output will be as shown below