Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

calculate Running Total

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...
Data Protection
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    5 years ago

    selimovd 

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

     

  • selimovd's avatar
    selimovd
    5 years ago

    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
     
  • selimovd's avatar
    selimovd
    5 years ago

    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
     

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

selimovd 

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

 

selimovd's avatar
selimovd
Icon for Most Valuable Professional rankMost Valuable Professional
5 years ago

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