Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
koorosh
Post Partisan
Post Partisan

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?

6 REPLIES 6
lbendlin
Super User
Super User

One thing is for sure - with this cavalier attitude to time formats you won't be on Santa's Nice list.

 

lbendlin_0-1709598110663.png

 

Ahmedx
Super User
Super User

pls try this

Screenshot_4.png

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.

koorosh_1-1709664073870.png

 

 

 

you explain where you got 45 hours and 20 minutes

koorosh_0-1709754259093.png

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

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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

March 2024 PBI Gallery Image

Power BI Monthly Update - March 2024

Check out the March 2024 Power BI update to learn about new features.