Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
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)
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
User | Count |
---|---|
93 | |
83 | |
77 | |
71 | |
65 |
User | Count |
---|---|
114 | |
101 | |
96 | |
65 | |
60 |