Forum Discussion

Pan_Forex's avatar
Pan_Forex
Icon for Helper III rankHelper III
3 years ago
Solved

Average from every day

Hi guys! I wonder if it is possible to create a table that adds new rows every day and leaves the old ones unchanged. I have a table that is updated several times every day with new rows and a second...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Pan_Forex 

    Please try

    New Table =
    ADDCOLUMNS (
    SUMMARIZE ( 'Table', [Date], 'Table'[Player] ),
    "Average Score",
    CALCULATE (
    AVERAGE ( 'Table'[Score] ),
    ALLEXCEPT ( 'Table', 'Table'[Player] ),
    [Date] <= EARLIER ( [Date] )
    )
    )

  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi Pan_Forex 

    this shall also work:

    Table = 
ADDCOLUMNS(
    SUMMARIZE(
        TableName,
        TableName[Date],
        TableName[Player]
    ),    
    "Avg",
    VAR _date=TableName[Date]
    RETURN CALCULATE(
    AVERAGE(TableName[Score]),
    TableName[Date]<=_date
    )
)

     

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Pan_Forex , try a measure with help from the date table

 

Cumm Sales = CALCULATE(AverageX(Values('Date'[Date]), CALCULATE(SUM(Table[Score]))) ,filter(all('Date'),'Date'[date] <=max('Date'[date])))

Pan_Forex's avatar
Pan_Forex
Icon for Helper III rankHelper III
3 years ago

Thank you for your reply. I would like the average to be calculated for each player separately and not all together from each day, and to create a new table with results only.