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 colu...
  • 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

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi TimoKosonen,

 

Is the result in the snapshot what you want?

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

How_to_create_data_to_column_from_existing_table

Best Regards,
Dale

TimoKosonen's avatar
TimoKosonen
Regular Visitor
7 years ago

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

 

 

 

 

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    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