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 change the format to "month year". But now I have multiple rows for the same month.
Currently my Matrix has hundreds of rows, and I want to group the rows for the same month to decrease the quantity of rows in the table.
Any advice would be immensely helpful. thankyou
11 Replies
HEllo StormyButter24 ,
if you have the month field as a first field in the rows then it should group them automatically.
Hi, unfortunately it hasnt. I'll show a photo.
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
Hi, StormyButter24
I'm happy to answer your questions. Based on your communication with Idrissshatila, I think you need that displays phone, task, Email and other information grouped by month, and counts each month. I create a matrix using the following sample data:
On date we enable hierarchy:
Here we only keep the month, and then put the other columns into the value of the matrix:
We can use the following formula to create a measure to work with the slicer to calculate count of phone calls, tasks and emails created each month:
Dax formula:
Total of months = CALCULATE(COUNTROWS('Tabelle1'),Tabelle1)Is the above the result you need? If not, please tell me the effect you want, and I will do my best to help you.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi
thank you for your response, with the hierarchy how did you get the month?
is it just by using the "MONTH()" formula?
