Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Greeting ,
so im imported some data from my cube , i created a paramter called year as text type and gave him the default value of 2012 and i decided to add that parameter to the MDX source query in my advanced editor , any tips or how i add that ?
FROM ( SELECT ( { [Axe Temps].[Temps].[Year].&[2012]} ) ON COLUMNS FROM [Sales Cube]) ==> this is the line where i want to add the parameter (i want to add year instead of the number 2012 )
thanks in advance
Please refer
https://community.powerbi.com/t5/Desktop/Passing-parameters-to-MDX-source-queries/td-p/98255
https://community.powerbi.com/t5/Desktop/Parameterized-MDX-query-for-PowerBI-reports/td-p/107309
https://community.powerbi.com/t5/Desktop/How-does-passing-a-parameter-to-MDX-works/td-p/153326
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |