Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

A new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.

Reply
koorosh
Post Partisan
Post Partisan

DAX

‎03-04-2024 01:12 PM

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?

Labels:
Message 1 of 7
987 Views
6 REPLIES 6
lbendlin
Super User
Super User

‎03-04-2024 04:22 PM

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

 

Proper Time.pbix
Message 7 of 7
947 Views
0
Ahmedx
Super User
Super User

‎03-04-2024 03:24 PM

pls try this

Screenshot_4.png

Message 2 of 7
949 Views
0
koorosh
Post Partisan
Post Partisan
In response to Ahmedx

‎03-05-2024 10:41 AM

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

 

 

 

Message 3 of 7
920 Views
0
Ahmedx
Super User
Super User
In response to koorosh

‎03-05-2024 04:55 PM

you explain where you got 45 hours and 20 minutes

Message 5 of 7
905 Views
0
koorosh
Post Partisan
Post Partisan
In response to Ahmedx

‎03-06-2024 11:45 AM

koorosh_0-1709754259093.png

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

Message 6 of 7
895 Views
0
lbendlin
Super User
Super User
In response to koorosh

‎03-05-2024 12:34 PM

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

Message 4 of 7
914 Views
0

Helpful resources

Announcements
May Power BI Update Carousel

Power BI Monthly Update - May 2026

Check out the May 2026 Power BI update to learn about new features.

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

View All