Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |