Forum Discussion

chavanr's avatar
chavanr
Resolver I
4 years ago
Solved

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
Need Help
  • chavanr's avatar
    chavanr
    4 years ago

    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's avatar
    jdbuchanan71
    4 years ago

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

     

  • chavanr's avatar
    chavanr
    4 years ago

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

chavanr's avatar
chavanr
Resolver I
4 years ago

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's avatar
chavanr
Resolver I
4 years ago

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