Cumulative Month to Date from average daily values

[lhdp]

Hi the community,

I need a relatively simple calculation: sum (or month-to-date) of average daily rainfall values ​​from different rain gauges. The calculation must be made regardless of the rain gauges(s) chosen by a slicer. I tried summarize or groupby and reach to have the calcultation for all rain gauges but I "lost" the rain gauges and I can't filter with my slicer.

Thanks for help!

Laurent

[lhdp]

Perfect. It's ok (and simple). Thanks to you YukiK.

[YukiK · Accepted solution]

You can use the formula like this:

Sum of Daily Rainfall Avg = 
SUMX(
    VALUES( Table[Date] ),
    CALCULATE( AVERAGE( Table[Rainfall] ) ) 
)

You iterate each date to calculate the average and you sum those calculated averages.

Please consider giving it a thumbs up and accept as solution if this helps!