Forum Discussion

TimoKosonen's avatar
TimoKosonen
Regular Visitor
7 years ago
Solved

How to create data to column from existing table

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's avatar
    v-jiascu-msft
    7 years ago

    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

7 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    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's avatar
      TimoKosonen
      Regular Visitor
      7 years ago

      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