Forum Discussion
PowerBI Olap Cube Variance Column Matrix
Hi everyone, Very new to PowerBI. I know I could do this all in excel in a second and schedule refreshes via powerautomate however I want the challenge of building powerBI dashboards. I want to use ...
Hi there,
Apologies for the delay, i was on vacation and thank you for taking the time to get back to me. I have successfully created the measure, however when I add it into my visual this is the result:
I would like 1 column for the account product, one for the Actual Amt $ and one for the budget amt $ and then the variance column at the end. Any advice?
Anonymous,
You may need to use MDX according to the article below.
https://learn.microsoft.com/en-us/system-center/scsm/olap-cubes-overview?view=sc-sm-2022
"After the raw data has been processed in an OLAP cube, users can perform more complex calculations and queries using multidimensional expressions (MDX) to define their own measure expressions or calculated members."