Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
Say I've got some data that looks like this in the table called SALES_TABLE.
I'm trying to get a summarized value by month and then find the monthly average. I tried this but it seems I am not allowed to reference the column of a table that is created by the SUMMARIZE function.
What is the way to achieve this?
Solved! Go to Solution.
Hi,
In the measure, if you created virtual table (temp_table) and wanted to use this virtual table, try writing the measure with averagex, something like below.
averagex(temp_table, [Monthly Sales])
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi,
In the measure, if you created virtual table (temp_table) and wanted to use this virtual table, try writing the measure with averagex, something like below.
averagex(temp_table, [Monthly Sales])
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Thanks @Jihwan_Kim! I knew it had to be a simple solution, I just couldn't figure out what it was!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
95 | |
77 | |
65 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |