Forum Discussion

kkalyanrr's avatar
kkalyanrr
Icon for Helper V rankHelper V
6 years ago

Connecting to Cube via Live Connection

Hello,

 

I am trying to connect to a Cube using Live connection, it has data from 2004 onwards, can I customize the input query so that I can get Data only from 2019 from the cube.

 

Thanks.

Need Help
Tips and Tricks

2 Replies

  • rajendraongole1's avatar
    rajendraongole1
    Icon for Super User rankSuper User
    6 years ago

    Hi

     

    I dont think  this custom MDX and DAX option is available to SSAS live connection .Here is a similar idea shared on Power BI Ideas. I have voted long back still i am waiting for this option to pull the data from cubes with custom queries.

     

    Regards,

    Rajendra

     
  • prakash11440278's avatar
    prakash11440278
    Icon for Post Prodigy rankPost Prodigy
    6 years ago

    Hi kkalyanrr ,

    You can create a measure below and use it in report level filter.

    Measure= IF(min(Table[date])=Calclate(max(table[date]),all(date)),1,0)