Forum Discussion
Grouping dates into months
Hi, I am newly introduced to power Bi and I want to have a matrix which shows the count of phone calls, tasks and emails created each month. I used the Created Date as the Rows and I managed to...
Hi,
Yeah I clicked matrix. In a table does it automatically group it?
no the matrix is who automatically group it,
do you have any other fields in the rows ?
Hi,
No, all I have in rows is the created date.
And I created the matrix again and it doesnt aggregate the months. Just hundreds of rows with the month and year for the row
remove the created date and create a calculated collumn for month year as the following
month year = format ('yourTableName'[created date],"mmmm YYYY")
and then use this collumn only in rows.
