How to create a derived column from a derived column

Question

I'm trying to create a derived column in Synapse Analytics. The new column basically checks whether "PackageDims" column is null/blank AND my derived column "No Length/ Width/ Height equals 1, if both is true then 1 else 0.

In DAX (Power BI), the syntax is as follows:

No Dimensions = IF(SupplyChainSLM[PackageDims] = BLANK() && SupplyChainSLM[No Length/ Width/ Height] = 1,1,0)

I'm recreating the logic in expression builder in Synapse Analytics and below is the code I thought should work. "PackageDims" column is original one but "No Length/ Width/ Height" column is a derived column and puts these curly brackets around it. Anyone knows what the syntax should be?

iif(isNull(PackageDims) && {No Length/ Width/ Height} = 1, 1,0)

Answer 1

Hi Lukas ,

Welcome to Microsoft Q&A platform and thanks for posting your question here.

As I understand your query, you are trying to create a new column based on another newly created column using Mapping dataflow. Please let me know if my understanding is incorrect.

The expression you have used is correct just replace '=' with '=='

Here are the images for your reference:

---

Hope it helps. Please do consider clicking Accept Answer and Up-Vote for the same as accepted answers help community as well