Create daily average for the month - new table

[easyleesie]

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? 

[mwegener]

Hi @easyleesie ,

What do you need the result in a new table for?
Have a look at the attached PBIX file.

[ryan_mayu · Accepted solution]

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

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