Forum Discussion
Total Revenue is Project forward
Hi Experts
I have a Total Revenue measure which has been written in the SSAS Cude, but when you plot the data it projects forward....so future revenue gives you the same number for Spet, Oct, Nov this year...
I am trying to write a new measure to compensate for this....
all i have is the Revenue measure....which i cannot see how this is written as the connetion from SSAS is a Live Connection....
Hi Route11,
If you are connecting to a SSAS multidimensional model, you can't create a measure in power bi, so you should modify or create a new measure in your SSAS model. In addtion, if your SSAS model is a tabular model, you can create measures in power bi.
Regards,
Jimmy Tao
2 Replies
- v-yuta-msftCommunity Support
Hi Route11,
If you are connecting to a SSAS multidimensional model, you can't create a measure in power bi, so you should modify or create a new measure in your SSAS model. In addtion, if your SSAS model is a tabular model, you can create measures in power bi.
Regards,
Jimmy Tao
- AnonymousNot applicable
Thanks Jimmy... much
appreciated