calculate Running Total

[Anonymous]

i have data like below with duplicate values in the avg column and  from the date i need month year as x-axis for the line chart.

i need to show the running total of the avg in line chart   removing that duplicates  values.

[Anonymous · Accepted solution]

@selimovd 

Thanks Getting the average correctly . is this measure can be used for creating the running total .

[selimovd · Accepted solution]

Hey @Anonymous ,

OK, so you want the running total over the column average. That's different to the running average.

What should happen on Januar 17?

Is January 2017 = 255+1789+247 + 1789 + 45

Or is January 2017 = 45

That was my question in the post before.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[selimovd]

Hey @Anonymous ,

you can get the correct average by removing the duplicates for your calculation.

Try the following measure:

Average = 
VAR vSummarizeTable = SUMMARIZE('myTable','myTable'[Date], 'myTable'[Avg])
RETURN
AVERAGEX(vSummarizeTable, 'myTable'[Avg])

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[Anonymous · Accepted solution]

@selimovd 

Thanks Getting the average correctly . is this measure can be used for creating the running total .

[selimovd]

Hey @Anonymous ,

you mean the running average?

Do you want to calculate the average from the beginning of the year to the day specified or from the beginning of all data up to the day specified?

For that you have to modify it a little, but I can do that if you tell me which of the two above you need.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[Anonymous]

@selimovd 

Expected Result

Running average 

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file.

[selimovd · Accepted solution]

Hey @Anonymous ,

OK, so you want the running total over the column average. That's different to the running average.

What should happen on Januar 17?

Is January 2017 = 255+1789+247 + 1789 + 45

Or is January 2017 = 45

That was my question in the post before.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[Anonymous]

@selimovd 

 January 2017 = 255+1789+247 + 1789 + 45

[selimovd · Accepted solution]

Hey @Anonymous ,

here you go:

Average = 
VAR vMinDate = FIRSTDATE(ALL('myTable'[Date]))
VAR vMaxDate = LASTDATE('myTable'[Date])
VAR vFilteredTable = FILTER(ALL('myTable'), 'myTable'[Date] >= vMinDate && 'myTable'[Date] <= vMaxDate)
VAR vSummarizeTable = SUMMARIZE(vFilteredTable,'myTable'[Date], 'myTable'[Avg])
RETURN
SUMX(vSummarizeTable, 'myTable'[Avg])

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic