topic Re: DAX Calculated Columns Help in DAX Commands and Tips

DAX Calculated Columns Help

Anonymous — Mon, 23 Jan 2023 15:35:19 GMT

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.

FreemanZ — Mon, 23 Jan 2023 15:50:09 GMT

hi Anonymous

could you elaborate this logic?

Anonymous — Mon, 23 Jan 2023 15:56:12 GMT

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

FreemanZ — Mon, 23 Jan 2023 16:04:56 GMT

hi Anonymous

try like:

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

Anonymous — Mon, 23 Jan 2023 16:13:38 GMT

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 — Mon, 23 Jan 2023 16:18:29 GMT

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.