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 that duplicates  values.

 

 

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
     

     

8 Replies

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

    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
     
    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      selimovd 

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

       

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

        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