Forum Discussion

Sébastien_S's avatar
Sébastien_S
Regular Visitor
6 years ago
Solved

year over year comparision with SSAS data source

Hello all,   Currently working on Power BI Desktop, i have a report with monthly data starting from january 2019. I would like to make a graph allowing to compare months from 2019 and 2020.   My...
Need Help
  • TomMartens's avatar
    TomMartens
    6 years ago

    Hey Sébastien_S ,

     

    it seems you have a live connection to SSAS Multidimensional.

     

    This means you can't achieve what you are looking for, as SSAS Multidimensional live connections do not allow creating report based measures.

     

    Without altering the SSAS measures you are stuck.

     

    Regards,

    Tom

     

Sébastien_S's avatar
Sébastien_S
Regular Visitor
6 years ago

Hello amitchandak ,

 

Thanks for the quick answer.

 

Unfortunately, i'm not able to create new measures since my data set is an SSAS cube, with direct connection.

 

Or I don't know how to do this.

 

TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
6 years ago

Hey Sébastien_S ,

 

it seems you have a live connection to SSAS Multidimensional.

 

This means you can't achieve what you are looking for, as SSAS Multidimensional live connections do not allow creating report based measures.

 

Without altering the SSAS measures you are stuck.

 

Regards,

Tom