Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
54 | |
27 | |
23 | |
14 | |
11 |
User | Count |
---|---|
77 | |
63 | |
44 | |
17 | |
12 |