Forum Discussion
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 ...
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.
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 DATE | AGE | RETAIL DATE | EXTERIOR DECOR | INTERIOR DECOR | ONLINE DATE | OFFLINE DATE |
hi Anonymous
try like:
Column =
IF(
[SHIP DATE]<>BLANK()&&[RETAIL DATE]=BLANK(),
"TRUE", "FALSE"
)