Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
TimoKosonen
Regular Visitor

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?

 

Capture.PNG

 

 

 

1 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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

7 REPLIES 7
v-jiascu-msft
Employee
Employee

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

 

 

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

 

example.PNG

 

 

 

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Confusing question.  What exact result do you want.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
PattemManohar
Community Champion
Community Champion

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





Did I answer your question? Mark my post as a solution!

Proud to be a PBI Community Champion




Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.