In Power BI I would like to make a chart showing the number of costumer service cases pr. costumer for every 30 month.
So fare, I have made a measurement giving me the number of cases every 30 month.
Every case has a uniqe case ID.
Cases each 30. day = CALCULATE([Number of cases], DATESINPERIOD('Page 1'[Updated].[Date],TODAY(),-30,DAY)).
So the question is: How can I relate that to each costumer?
I hope someone can help. Thanks in advance!
BR Rebekka.