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.

[Syndicate_Admin]

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.

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

[Syndicate_Admin]

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

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

[Syndicate_Admin]

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