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?
Did I answer your question? Mark my post as a solution. Proud a to be a Datanaut!