Total Revenue is Project forward

[Anonymous]

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....

[v-yuta-msft · Accepted solution]

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

[Anonymous]

Thanks Jimmy... much

appreciated