Forum Discussion

MH-ofHC's avatar
MH-ofHC
New Member
2 years ago
Solved

Can a Measure = calculation use a Parameter Value?

I am trying to create a Status Board based on submitted Parameters.   The parameters I have created are: Goal (Number) Shift Start (Time) Shift End (Time) Break_Lunch (Number)   I am trying t...
measure
Time Parameter
  • MH-ofHC's avatar
    MH-ofHC
    2 years ago

    I found the solution.

    Looks like Measure does not like spaces in object names.

     

    I ended up creating 3 Measure objects to get the correct value:

    Clock_Hr = FORMAT(NOW(), "hh") - FORMAT(Shift_Start, "hh")

    Clock_Min = FORMAT(NOW(), "n") - FORMAT(Shift_Start, "n")

    Clock = ([Clock_Hr] * 60) + [Clock_Min]

  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    Hi MH-ofHC 
    The error that you are getting is because the function now returns a date /time and not a time:

    To get the desired result try :

    Diff_now = DATEDIFF( TIME(  HOUR(  NOW()  ),  MINUTE(  NOW()  ),  SECOND( NOW())),max('Table'[Start]),MINUTE)

    pbix is attached

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

MH-ofHC's avatar
MH-ofHC
New Member
2 years ago

I found the solution.

Looks like Measure does not like spaces in object names.

 

I ended up creating 3 Measure objects to get the correct value:

Clock_Hr = FORMAT(NOW(), "hh") - FORMAT(Shift_Start, "hh")

Clock_Min = FORMAT(NOW(), "n") - FORMAT(Shift_Start, "n")

Clock = ([Clock_Hr] * 60) + [Clock_Min]