Forum Discussion

james_pbi's avatar
james_pbi
Frequent Visitor
5 years ago

When did/why did MS get so bad?

So, my business has spent thousands on Power BI and is still no better than using Excel. I stupidly thought it would be easy to find solutions to issues, like it was with Excel. Wrong!   I've spent...
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

No, I did not mean hh:mm:ss. I suggested you use the Format function to convert numbers to text, which would allow you to have an hour count greater than 24. You can still combine that with mm:ss if you want.

  • james_pbi's avatar
    james_pbi
    Frequent Visitor
    5 years ago

    Sorry, getting confused with where your replies posted. Sorry, with you not specifying Format as TEXT I assumed you meant format as hh:mm:ss as that is what the results actually is hours, minutes and seconds.

    FORMAT() as text? How do you do that then? I can't see anything on docs.microsoftc.com or dax.guide.

    Converting to text within the data itself does not allow the result to go over 24 hours, nor does it allow you to summerise.