Forum Discussion
Community ChampionDisplaying Duration in visuals
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?
Yeah, unfortunately live connections to multidimensional MDX cubes do not support either DAX calculated columns or DAX calculated measures.
5 Replies
- Greg_Deckler
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
- vanessafvg
Greg_Deckler - thanks problem is im using a direct connection to a multi dimensional cube, any suggestions around that
- Greg_Deckler
Yeah, unfortunately live connections to multidimensional MDX cubes do not support either DAX calculated columns or DAX calculated measures.
