Forum Discussion
Can a Measure = calculation use a Parameter Value?
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]
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
I hope this clarifies,
Data from Manage Parameters that is included with a imported Oracle Database query:
| Column Name | Column Value |
| Goal | 30 |
| Shift Start | 5:30:00 AM |
| Shift End | 4:00:00 PM |
| Break_Lunch | 75 |
On my PowerBI report, I click the Oracle Database query and choose 'New Measure'
Top of the report it shows Measure =
I add the follow value: Measure = DATEDIFF(NOW(), Start Shift, Minute)
I get error: The syntax for 'Start' is incorrect. (DAX(DATEDIFF(NOW(), Shift Start, MINUTE))).
- Ritaf1983
Super User
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