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
    )
)

     

     

FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
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
    )
)