How to create data to column from existing table

[TimoKosonen]

I can get this kind of data. Data contains thousands rows. My need is get to actual factory column to all rows 0008. and other factory.  This is easy to do to those rows where at Production area column, there is KANK term available.

Actual Factory = IF(ISNUMBER(SEARCH("KANK";ZMDWF[Production area];;BLANK()));"0008")

but how I can get this 0008 to each rows?

[v-jiascu-msft]

Hi @TimoKosonen,

There is only one "KANK***" in the data. How can we get "0008" to each row? Which rows? All the rows?

Is there only one condition or requirement? 

Please provide a DUMMY sample file that we can download.

Best Regards,
Dale

[TimoKosonen]

Below there is data example. All same SD doc numbers need to be manufactured at same factory.  Hopefully this helps.

Data example is .pbix file. 

Power BI data example

[v-jiascu-msft]

Hi @TimoKosonen,

Is the result in the snapshot what you want?

Actual Factory =
CALCULATE ( MIN ( [Factory] ), ALLEXCEPT ( ZMDWF, ZMDWF[SD Doc.] ) )

Best Regards,
Dale

[TimoKosonen]

This is partial solution. how I can add other factory?  Please look picture what is need to me,

[v-jiascu-msft · Accepted solution]

Hi @TimoKosonen,

So what are the rules? You can add it yourself. Then the [Actual factory] will be filled automatically.

Factory =
SWITCH (
    TRUE (),
    ISNUMBER ( SEARCH ( "Kank", 'ZMDWF'[Production area],, BLANK () ) ), "0008",
    ISNUMBER ( SEARCH ( "oth", 'ZMDWF'[Production area],, BLANK () ) ), "0001",
    "9999"
)

Best Regards,
Dale

[Ashish_Mathur]

Confusing question.  What exact result do you want.

[PattemManohar]

@TimoKosonen Please post the sample data (which is easy to copy and paste) to solve your issue quickly.