Connecting to Cube via Live Connection

[kkalyanrr]

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.

[prakash11440278]

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)

[rajendraongole1]

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