Forum Discussion

E_Rye's avatar
E_Rye
Frequent Visitor
7 months ago
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...
General Comment
Need Help
Tutorial Requests
  • krishnakanth240's avatar
    krishnakanth240
    7 months ago

    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])))