Forum Discussion

chavanr's avatar
chavanr
Icon for Resolver I rankResolver I
5 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
jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
5 years ago

The problem is with the " " portion.

 

chavanr's avatar
chavanr
Icon for Resolver I rankResolver I
5 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
    Icon for Super User rankSuper User
    5 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
    Icon for Resolver I rankResolver I
    4 years ago

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