Forum Discussion

RP_OFaustino's avatar
RP_OFaustino
Helper I
3 years ago
Solved

Running Sum Bar Graph Displaying Months Without Values

HI PBI Community,   I have this Running Sum Bar and Line Graph:   As you can see everything is fine in the column chart until June 2023. But for July to December, they are displaying th...
Need Help
  • Ahmedx's avatar
    Ahmedx
    3 years ago

    pls try this

    Running Sum (Gross Leads) =
IF( MAX('Date'[Date]) <= DATE(2023, 6, 30),
CALCULATE(SUM('Overall Weekly Leads'[Counter]),
FILTER(ALL(
    'Date'[Date]),'Date'[Date] <= MAX('Date'[Date]) && 'Date'[Date] <=DATE(2023, 6, 30))))
RP_OFaustino's avatar
RP_OFaustino
Helper I
3 years ago

Dear Sir Ahmedx  a little tweak of the code and it works!

Running Sum (Gross Leads) = 
IF(MAX('Date'[Date]) <= DATE(2023,6,30),
CALCULATE(SUM('Overall Weekly Leads'[Counter]),
FILTER(ALL(
    'Date'[Date]),'Date'[Date] <= MAX('Date'[Date]) && 'Date'[Date] <=DATE(2023, 6, 30))),0)

Thank you!