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

     

     

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

thank you for your reply. Your solution works but I would still like to have this data in a new table and not as a measure. Is this possible? 

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
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] )
)
)