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
Ahmedx's avatar
Ahmedx
Super User
2 years ago

pls try this

  • 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.

    • Ahmedx's avatar
      Ahmedx
      Super User
      2 years ago

      you explain where you got 45 hours and 20 minutes

      • koorosh's avatar
        koorosh
        Post Partisan
        2 years ago

        I want on visual card written "25 hours and 35" minutes.