Forum Discussion
Solved
Create Summy Table
I have a large data set with Date and Status. Status includes Assigned, In Progress and Complete. I want to create a dynamic summary of the count of Complete and Total by Month. The total will be t...
user900 , for the First three columns use Group by of Power Query, and for % create a measure in DAX
Divide(Sum(Table[Complete]), Sum(Table[Total]) )
Hi,
Try this approach
- Create a Calendar Table with calculated column formulas for Year, Month name and Month number. Sort the Month name column by the Month number column
- Create a relationship (Many to One and Single) from the Date column of your Data Table to the Date column of the Calendar Table
- To your Table visual, drag Year and Month name from the Calendar Table
- Write these measures
Total = countrows(Data)
Complete = calculate([Total],Data[Status]="Complete")
Complete (%) = divide([Complete],[Total])
Hope this helps.