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.
I am using an MDX cube with a direct connection so i am unable to calculate duration. Also using Power BI Report server if that makes any difference. There is no duration data type as far as I know. What is the best way to display this, using text is obviously not the ideal.
Just wondering what other people have been doing?
Proud to be a Super User!
Solved! Go to Solution.
Yeah, unfortunately live connections to multidimensional MDX cubes do not support either DAX calculated columns or DAX calculated measures.
Yeah, it's an issue that I have been discussing for like two years now, the lack of a true duration data type or format display in DAX. Generally, you have to do things as discussed in this article:
https://community.powerbi.com/t5/Community-Blog/Aggregating-Duration-Time/ba-p/22486
Obviously it ends up as text, which is the issue I've discussed with the product team at the last MVP conference.
I also have a Quick Measure for doing the reverse:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Duration-to-Seconds-Converter/m-p/342279
@Greg_Deckler - thanks problem is im using a direct connection to a multi dimensional cube, any suggestions around that
Proud to be a Super User!
Yeah, unfortunately live connections to multidimensional MDX cubes do not support either DAX calculated columns or DAX calculated measures.
Oh shoot, you did say that. Let me see if I can work up a way to do it with valid DAX functions in DirectQuery.
@Greg_Deckler sorry thats live query connection to SSAS MDX, so i have 0 control of creating any measure too.. guess it will have to be text then?
Proud to be a Super User!
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 |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |