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

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

easyleesie , Assume you have date in the table. Have a month year in your table or date table

 

Month Year = format([date],"YYYYMM")

 

Try a measure like

Averagex(Summarize(filter(Table, Month(Table[Date])=1),Table[Month Year], "_1", Sum(Table[Value])),[_1])

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

Thanks a lot. I'm going to reply and I'll tell you.