Hi Everyone, I have been scrolling for a few days, but I must turn it in here as I need a solution to match my search. I have a few columns I unpivoted to obtain a single column of the different categories I wanted to report. These categories are milestones that will be achieved throughout dated periods. I want to create a cumulative count by category that groups the counts of those milestones by category occurring in the same month. The picture reflects the source data from which I want to achieve this.
🔺[Milestones Label]: Column I want to report separately
🔹[Milestones Forecast]: Real date of occurrence
💚[Milestones Int]: all milestones are formatted to the 1st of each month. Thought to be needed for monthly cumulative count.
💜[Milestones_Month_Year]: The column use as table headers to report the cumulative count by category
◼️[Milestones Count Live Building Schedules]: Cumulative counts values
Here is the excel table with the milestones cumulative count by date I am trying to achieve in powerbi:
Here the formula among others I have tried so far with no success
Milestones Count Live Building Schedules = CALCULATE(COUNTA('140 Milestones Draft'[Milestone Label]), FILTER('140 Milestones Draft','140 Milestones Draft'[Milestone_Month_Year]<=EARLIER('140 Milestones Draft'[Milestone_Month_Year])&&'140 Milestones Draft'[Milestone_Int]<=EARLIER('140 Milestones Draft'[Milestone_Int])))
Thank you so much in advance!