Forum Discussion

Link2mukesh's avatar
Link2mukesh
New Member
1 year ago

Regarding Running Total count.

Hi All,

 please suggest how show running in visual when prepared date are in one column and approved date are in another column, we need show running total on line chart both approved count and prepared count.

Learn Together

1 Reply

  • Shahid12523's avatar
    Shahid12523
    Icon for Community Champion rankCommunity Champion
    1 year ago

    Use this

    Running Prepared =
    CALCULATE(
    COUNTROWS(FILTER(YourTable, NOT ISBLANK(YourTable[PreparedDate]))),
    FILTER(ALL('DateTable'[Date]), 'DateTable'[Date] <= MAX('DateTable'[Date]))
    )

    Running Approved =
    CALCULATE(
    COUNTROWS(FILTER(YourTable, NOT ISBLANK(YourTable[ApprovedDate]))),
    FILTER(ALL('DateTable'[Date]), 'DateTable'[Date] <= MAX('DateTable'[Date]))
    )