Grouping dates into months

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.