Forum Discussion
Running Total - Data Source SSAS MutiDimensional Cube
Hi, I would like to create a formula to calculate a Running Total in a Power BI Report. The source is a DataSet having a direct connection to an SSAS MultiDimensional Cube. I tried using Quick Measu...
You cannot create Calculated Members in Power BI Desktop using Live connection that you normally create under Excel OLAP tools.
unfortunately, you need to create such calculations at SSAS level.
If you read the full thread you will see that I am able to create fomulas with a live connection to OLAP THROUGH A DATASET USING A GATEWAY.
THANKS