Forum Discussion

CraigBlackman's avatar
CraigBlackman
Helper III
10 years ago

Problems working out my IF statement to return a Value.

I am trying to create a new measure that returns the result "Re-Stock"

 

Thi is what I am trying to acheive.

 

IF StockLocation = Warehouse AND FreeStockQuantity is <5 AND StockLocation = RTP & FreeStockQuantity >0 Then "Re-Stock"

 

I can't get work out the dax to do so.

 

Thanks

 

Craig

Need Help
Show and Tell

1 Reply

  • JBeyers's avatar
    JBeyers
    Advocate IV
    10 years ago

    First remark is that you will need a value_if_true and a value_if_false in your IF Function. 

    The IF Function works as follows:

     

    var <var1> =  IF(<conditions>; <return if true>; <return if false>)

    Here is a working example: 

    var length = LEN([variable])
    var result = IF(length>8; RIGHT([variable];8);"null")