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