Forum Discussion
PowerBiNoob37
Helper I
Helper ICount Values from one table using based on month and year and add to another table (Pbix included)
Hi, I have a bit of incident data coming from a sharepoint list, every row contains a date of incident and incident type which is a choice field. Here is a sample of my data ...
Power Query:
Add a column for 1st day of the month (can do this from the interface->Select date column, go to Add Column-> From Date and Time on the ribbon)
Remove the original date column.
Group By StartOfMonth and Incident using Count Rows as aggregation.
This gives a 3 column table which is pretty good for storage and analysis.
If you want a table as shown, then Pivot the IncidentType column
v-henryk-mstf
Community Support
Community SupportHi PowerBiNoob37 ,
Whether the advice given by HotChilli has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.
Looking forward to your feedback.
Best Regards,
Henry