Forum Discussion

koorosh's avatar
koorosh
Post Partisan
2 years ago

DAX

Hi All,
What is the DAX formula for a visual card that shows 11.45 as 11 hours and 45 minutes and shows 11.70 as 12 hours and 10 minutes?

Need Help

6 Replies

    • koorosh's avatar
      koorosh
      Post Partisan
      2 years ago

      Hi Ahmed and Ibendin,

      The following table shows the daily work hours for a person. I want to show in a visual card how many hours and how many minutes the person worked. For instance 45 hours and 20 minutes.

       

       

       

      • lbendlin's avatar
        lbendlin
        Super User
        2 years ago

        You need to use the same approach. Add the fractions separately from the integers.   Mod the fractions by 60.