Forum Discussion

easyleesie's avatar
easyleesie
Icon for Helper I rankHelper I
5 years ago
Solved

Create daily average for the month - new table

Hi all   I have a table with daily values:   1 Jan: 10 3 Jan: 15 4 Jan: 20  etc   I would like to have a new table with  Jan: average for table above (in this case 15)   How do I do this?...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    5 years ago

    easyleesie 

    based on the sample data you provided, you can try this to create a new table.

    Table 2 = 
VAR tbl=ADDCOLUMNS('Table',"Month",FORMAT('Table'[date],"mmm"))
return SUMMARIZE(tbl,[Month],"average",AVERAGE('Table'[value]))

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
5 years ago

easyleesie 

based on the sample data you provided, you can try this to create a new table.

Table 2 = 
VAR tbl=ADDCOLUMNS('Table',"Month",FORMAT('Table'[date],"mmm"))
return SUMMARIZE(tbl,[Month],"average",AVERAGE('Table'[value]))

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
2 years ago

Thank you. I'm going to reply and I'll tell you.