Forum Discussion

PowerBIBeginer's avatar
PowerBIBeginer
Icon for Helper V rankHelper V
4 years ago

Design Dax formula - with Multiple Ifs condition

Hello All Power Bi Board Members, I need one help in design Dax formula. Below my formula is in Excel, I want to convert this in Dax. Could anyone help/guide me on this..   Col AO name = Request ...
Need Help
v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, PowerBIBeginer ;

Your dax cannot output both numbers and text. You have to pick one or the other. 

To fix this, you can convert the number to text using the FORMAT function:

INT ( 24 * MAX ( [Time Taken] ) )

change it like belows:

FORMAT ( INT ( 24 * [Time Taken] ), "0" )

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

PowerBIBeginer's avatar
PowerBIBeginer
Icon for Helper V rankHelper V
4 years ago

Thanks for again reply to my query. This is really appriciate.

 

But now after applying this, I'm getting error msg -

"DAX comparison operations do not support comparing values of type Text with values of type Integer. Consider using the VALUE or FORMAT function to convert one of the values."

 

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi, PowerBIBeginer ;

    Can you share me simple file or screenshot about your data and error  without sensitive information? It's not clear here what your [Time Taken] format is?

    I suspect that there is a problem in INT (24 * [Time Taken]) >= 36 or [Time Taken] >= TIMEVALUE ("02:30:00") .

    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • PowerBIBeginer's avatar
      PowerBIBeginer
      Icon for Helper V rankHelper V
      4 years ago

      Hello Sir, Thanks for replying me.

       

      I've some couple of question's.. could you pls suggest on the same..

      1. The column in which we're trying to get this output, should be what data type?

      = Numeric Or Text?

       

      2. Time Taken column has below formatting.

      data type = Decimal number

      Format = whole number

      Is this correct?

       

      3. Request type column has below formatting.

      data type = Text

      Format = Text

      Is this correct?

       

      Let me please correct on this first.. Thanks