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 have a direct query model and want to calculate CAGR but the calculate function doesn't work with direct query (https://powerbi.tips/2016/05/measures-calculate-cagr/). Is there an alternative to calculate function in direct query, to calculate CAGR?
Thank you. Would appreciate some help.
Solved! Go to Solution.
The link returns a 500 error and can't be loaded when I post. If you could share any information on the CAGR formula, maybe we can replicated the same in DAX.
By the way, in case you're talking about the measure limitation in DirectQuery mode, you can try to click "File"->"Options and settings"->"Options"->"DirectQuery"->check "allow unstricted measures"
The link returns a 500 error and can't be loaded when I post. If you could share any information on the CAGR formula, maybe we can replicated the same in DAX.
By the way, in case you're talking about the measure limitation in DirectQuery mode, you can try to click "File"->"Options and settings"->"Options"->"DirectQuery"->check "allow unstricted measures"
Thank you! Worked perfectly! Although I wonder why MS would restrict certain measures from DAX as default.
For performance improment in DirectQuery mode, check the DirectQuery limitation.
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 |
---|---|
111 | |
94 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |