Forum Discussion
Does value fall in specific month
Hello PBI community!
I have a task that I am struggling with and hope someone can help me out.
I have this Main table (for the sake of the example I have only included 2 clients):
| Client | Start Date | End Date |
A | 01/01/2023 | 01/03/2023 |
B | 01/01/2023 | 01/06/2023 |
I also have a standard calendar table with dates.
What I would like to achieve, is to create a summary table which has all of the dates in the Calendar table as month and year as one column and another column that counts whether a client was active for the specific month.
For example, client A starts from Jan and ends in Mar so it would be counted for Jan, Feb. Client B starts from Jan and ends Jun, so it will be counted for Jan, Feb, Mar, Apr, May.
Example table below:
| Date | Client count |
| Jan | 2 |
| Feb | 2 |
| Mar | 1 |
| Apr | 1 |
| May | 1 |
I would really appreciate any help.
Hello SGBaringa,
While not a direct solution this should provide you with some ideas Events in progress – DAX Patterns
Hope this helps
2 Replies
- collinsgSolution Sage
Hello SGBaringa,
While not a direct solution this should provide you with some ideas Events in progress – DAX Patterns
Hope this helps
- SGBaringaFrequent Visitor
Amazing! Thank you!