Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

DAX Calculated Columns Help

I need help, I am trying to figure out how to write a True/False DAX expression for current inventory. 

Something like this 

 

Current inventory = Ship Date is not blank 

Retail Date is blank 

 

But im not quite sure how to tie those together. 

DAX
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi Anonymous 

    the screenshot suggests you are adding a custom column in Power Query, while the code above is for a calculated column with DAX. 

     

5 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Here is a snippet of a few of the columns i have and each row represents 1 unit of our product. 

       

      I need a calculated column that will take the ship date and retail date and give me a true/false value 

       

      where true would = Not blank or null in [SHIP DATE] and Blank or null in [RETAIL DATE] 

       

      False would be = Not blank or null in [SHIP DATE] but blank or null in [RETAIL DATE]

       

      SHIP DATEAGERETAIL DATEEXTERIOR DECORINTERIOR DECORONLINE DATE OFFLINE DATE
      • FreemanZ's avatar
        FreemanZ
        Super User
        3 years ago

        hi Anonymous 

        try like:

        Column =
        IF(
        [SHIP DATE]<>BLANK()&&[RETAIL DATE]=BLANK(),
        "TRUE", "FALSE"
        )

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Its giving me an error code. 

     

    I would need the [SHIP DATE] to not be blank though it has to have a date value, the [RETAIL DATE] would be blank for true and not blank for false 

     

    • FreemanZ's avatar
      FreemanZ
      Super User
      3 years ago

      hi Anonymous 

      the screenshot suggests you are adding a custom column in Power Query, while the code above is for a calculated column with DAX.