Format error when creating measure

[chavanr]

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

[chavanr · Accepted solution]

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.

[jdbuchanan71 · Accepted solution]

@chavanr 

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

[jdbuchanan71]

The problem is with the " " portion.

[chavanr · Accepted solution]

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.

[chavanr · Accepted solution]

i have done the transformation in m query using If with conditional column

[jdbuchanan71 · Accepted solution]

@chavanr 

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