Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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?
Solved! Go to Solution.
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]))
Proud to be a Super User!
Hi @easyleesie ,
What do you need the result in a new table for?
Have a look at the attached PBIX file.
Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials
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.
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]))
Proud to be a Super User!
Thank you. I'm going to reply and I'll tell you.
@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])
Thanks a lot. I'm going to reply and I'll tell you.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
89 | |
82 | |
76 | |
64 |
User | Count |
---|---|
142 | |
111 | |
108 | |
99 | |
95 |