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

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

I saw your file, thank you very much. However, there may be a need to have control over the results (the Average, Cumulative, etc.), which is not discussed here. I do not omit to point out that your contribution supports. In my case, it doesn't support me.