Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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-msft's avatar
    v-yuta-msft
    Community 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

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks Jimmy... much

      appreciated