Forum Discussion
Solved
Running Monthly Total Calculation or Filter
Good day, Will someone please help me understand the steps to create a running monthly total that can be filtered by dates/conditions? All my data is in one table (Episodes) with one row per un...
Hi E_Rye
Create a Date table( please check this post - https://community.fabric.microsoft.com/t5/Desktop/Creating-Date-Tables/m-p/553980) then provide relationship based on date column from Date table to your Main table
Create a measure
Active IDs =
CALCULATE(COUNTROWS(Episodes),FILTER(Episodes,Episodes[Episode Start Date <=MAX(Date[MonthEnd] )&&(
ISBLANK( Episodes[Delivery Date])
|| Episodes[Delivery Date]>=MIN(Date[MonthStart]))))Cumulative Active IDs =CALCULATE([Active IDs],
FILTER(ALL(Date[Date]),Date[Date]<=MAX( Date[Date])))
If this solution worked for you, please Mark as Solution! It helps others in the community find this answer more easily. Cheers!