Forum Discussion

inawab's avatar
inawab
Frequent Visitor
4 years ago
Solved

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

 

 

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

 

Need Help
  • v-xiaotang's avatar
    v-xiaotang
    4 years ago

    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])

     

    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.

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

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

    Appreciate your Kudos.

  • v-xiaotang's avatar
    v-xiaotang
    Icon for Community Support rankCommunity Support
    4 years ago

    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])

     

    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.