time

[AtchayaP]

type	Spend time
male	0.5
male	0.25
female	1
female	1.25
Female.	0.35

I have this column in dataset. this is the spent time on survey for male and female.But it is in decimal. My question is  How much time spent on males and females.?

How can I bring time value in card visual(If I do i will get in decimal). Should simply drag and drop time spent column in card visual or should I change datatype.

[ALLUREAN · Accepted solution]

Hi, @AtchayaP 

Check this sample:

https://www.dropbox.com/s/p488r9x6wic70md/time%20%28allure-analytics.com%29.pbix?dl=0

Did I answer your question? Please Like and Mark my post as a solution if it solves your issue. Thanks.

Appreciate your Kudos !!!

https://allure-analytics.com/

https://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA

https://www.linkedin.com/company/77757292/

[mahoneypat · Accepted solution]

Please also see this article on a good way to calculate and format durations. You should keep your column as decimal to make the math/expression easy, but you can easily format it to look like a time/duration in your measure.

Calculate and Format Durations in DAX – Hoosier BI

Pat

[ALLUREAN · Accepted solution]

Hi, @AtchayaP 

Check this sample:

https://www.dropbox.com/s/p488r9x6wic70md/time%20%28allure-analytics.com%29.pbix?dl=0

Did I answer your question? Please Like and Mark my post as a solution if it solves your issue. Thanks.

Appreciate your Kudos !!!

https://allure-analytics.com/

https://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA

https://www.linkedin.com/company/77757292/