Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |