cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
inawab
Frequent Visitor

Time pried for a shift

Hi Everyone,

 

I want to make a code to be reference for a Time pried in the day

the shift starts from 7:00:00 AM and end at 3:00:00 PM

 

inawab_0-1657024140414.png

 

What I want is to be able to say Shift A start from 07:00 and end at 03:00 and reflected on the dashboard

 

1 ACCEPTED SOLUTION
v-xiaotang
Community Support
Community Support

Hi @inawab 

Thanks for reaching out to us.

>>What I want is to be able to say Shift A start from 07:00 and end at 03:00 and reflected on the dashboard

please try this measure, 

Measure = "Shift"& MIN('Table'[Column1]) & " start from" &MIN('Table'[Column2])& " and end at "& MIN('Table'[Column3])

vxiaotang_0-1657274643697.png

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-xiaotang
Community Support
Community Support

Hi @inawab 

Thanks for reaching out to us.

>>What I want is to be able to say Shift A start from 07:00 and end at 03:00 and reflected on the dashboard

please try this measure, 

Measure = "Shift"& MIN('Table'[Column1]) & " start from" &MIN('Table'[Column2])& " and end at "& MIN('Table'[Column3])

vxiaotang_0-1657274643697.png

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

amitchandak
Super User
Super User

@inawab ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.



Power BI Features || Datamarts: https://youtu.be/8tskWsJTEpg || Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Time Intelligence Decoded : https://youtu.be/aU2aKbnHuWs&t=145s || 50+Power Query List Functions : Learn Power Query List
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Dashboard of My Blogs !! Connect on Linkedin !! Subscribe to my youtube Channel !!
Want To Learn Power BI | Beginners !! Advance Concepts !! Power BI For Tableau User !!

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show episode 9

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 25

Ted's Dev Camp - August 25, 2022

Watch Session 25 of Ted's Dev Camp.

Top Solution Authors