Forum Discussion
chavanr
4 years agoResolver I
Format error when creating measure
Hi there,
I have created a measure which is giving following error
All the fields are in date/time format.
Just wondering still giving the above error.
Cheers
Yes, i understand that but how do we handle because i want to use it as a condition where there is blank it should consider value from another column.
Try it like this.
Time out testing = IF ( 'Weighing Details New'[Time Out] = BLANK (), 'Weighing Details New'[New Weighing data.Timeout], 'Weighing Details New'[Time Out] )or this
Time out testing = IF ( ISBLANK ( 'Weighing Details New'[Time Out] ), 'Weighing Details New'[New Weighing data.Timeout], 'Weighing Details New'[Time Out] )or this
Time out testing = COALESCE ( 'Weighing Details New'[Time Out], 'Weighing Details New'[New Weighing data.Timeout] )i have done the transformation in m query using If with conditional column
4 Replies
- jdbuchanan71Super User
The problem is with the " " portion.
- chavanrResolver I
Yes, i understand that but how do we handle because i want to use it as a condition where there is blank it should consider value from another column.
- jdbuchanan71Super User
Try it like this.
Time out testing = IF ( 'Weighing Details New'[Time Out] = BLANK (), 'Weighing Details New'[New Weighing data.Timeout], 'Weighing Details New'[Time Out] )or this
Time out testing = IF ( ISBLANK ( 'Weighing Details New'[Time Out] ), 'Weighing Details New'[New Weighing data.Timeout], 'Weighing Details New'[Time Out] )or this
Time out testing = COALESCE ( 'Weighing Details New'[Time Out], 'Weighing Details New'[New Weighing data.Timeout] )