Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, I am trying to show a line chart in Power BI based on a DateDiff column. The example in Excel is attached as well as how it currently looks in Power BI. Any suggestions on how I can do a Sum (running total) of the value then show the line graphs as a cummulative total of the values called R1000?
X Axis = Date Diff "MIS" 1 through 50
Y Axis = Cumulative total "R1000" based on the prior Date Diff value
Legend = 2018, 2019, 2020
Solved! Go to Solution.
Hi here is what I think gets you what you are looking for
Cummulative R1000 =
CALCULATE(
[R1000],
filter(
allselected('warranty'[MIS]), 'warranty'[MIS]<=max('warranty'[MIS])
)
)
Also find the updated pbix
Proud to be a Super User!
Hi @efowler ,
Below you will find an example of a running total calculation, that should get you going in the right direction.
Cummulative R1000 =
Calcluate(
SUM('table'[R1000]),
filter(
allselected('table'[MIS (Failure)]), 'table'[MIS (Failure)]<=max('table'[MIS (Failure)])
)
)
Hope that helps,
Proud to be a Super User!
Hi, thanks.. R1000 is a measure. Does that make a difference? I can not find the 'table'[R1000], I believe that is because it is a measure?
Hi @efowler ,
'table' is a place holder as i do not know the name of your table, for the measure name please leave out the table name
Proud to be a Super User!
I can't add my table because the data I am trying to create the running total on is a measure. The MIS is a calculated column
Hi @efowler ,
Please provide a sample pbix file, will make it much easier to craft a working measure for you
Proud to be a Super User!
Hi here is what I think gets you what you are looking for
Cummulative R1000 =
CALCULATE(
[R1000],
filter(
allselected('warranty'[MIS]), 'warranty'[MIS]<=max('warranty'[MIS])
)
)
Also find the updated pbix
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |