Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

DAX and variant data type

Hi,   I'm trying to replicate this excel formula in Power BI =IF([@[Ex Factory Allocated]]="Shipped","Shipped",H2-G2)   But when i try and insert a column i get this:    My Ex Factory Allo...
Need Help
AkhilAshok's avatar
AkhilAshok
Solution Sage
7 years ago

You could try using a FORMAT function in the else part:

FORMAT([...Requested]-[...Allocated], "General Number")

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi AkhilAshok,

 

Thank you for your reply! However, it states that there are too few arguments for the FORMAT function.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Anonymous ,

    I'd like some sample data for test, it will be help for coding formula.
    BTW, please check MSDN library for dax format functions, you are typing wrong 'format' expression in 'if' statement.

    FORMAT funtion

    Regards,

    Xiaoxin Sheng