Forum Discussion
Solved
Count by month
Hi, I have data like below: I want to create a visual on PowerBI to show the count of cases monthly, including opening balance (cases that opened in last month but not yet closed), ...
Hi raymondchen ,
Like this?
Please refer to my pbix file for better understanding.
Best regards,
Community Support Team Selina zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hey, try to create a column in PQ with dates between Start and End date, then link your calendar table with this new created column, your model will be bigger but you will have a record for each day and you can count them afterwards.
Sorry I am not quite understand. What do you mean by Start and End date? And how to get the count by linking to calendar table?
