Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
I have a very simple measure but the latest month is displaying zero since I have not added anything new for the latest month. In this scenario how can I get the value from last month instead of displaying zero?
Measure below:
Running Total =CALCULATE([Discovered Servers],FILTER(ALL(chargeableserverstrendreport), chargeableserverstrendreport[Discovery Date] <= MAX (chargeableserverstrendreport[Discovery Date])))
chargeableserverstrendreport has a relationship with my date table and display running total per month using the month field from the date table
My data below, I need the Running Total for Feb2023 to show 9 instead of zero
Month | Count | Running Total (what I'm getting) | Running Total (what I need) |
Oct2022 | 1 | 1 | 1 |
Nov2022 | 3 | 4 | 4 |
Dec2022 | 3 | 7 | 7 |
Jan2023 | 2 | 9 | 9 |
Feb2023 | 0 | 0 | 9 |
Total | 9 | 9 | 9 |
[Discovered Servers] is a measure, right? I miss a sumx or something in the caluclate function.
You can try this:
Running Total =
Var _discover = [Discovered Servers]
Var _function =
CALCULATE([Discovered Servers],FILTER(ALL(chargeableserverstrendreport), chargeableserverstrendreport[Discovery Date] <= MAX (chargeableserverstrendreport[Discovery Date])))
RETURN if(_discover=0,0,_function)
Proud to be a Super User!
User | Count |
---|---|
11 | |
9 | |
6 | |
5 | |
4 |