Forum Discussion

lboldrino's avatar
lboldrino
Icon for Resolver I rankResolver I
5 years ago
Solved

Create a new column from more columns other table

i have two tables_ fact_fahrzeuge: kennzeichen W12300 W12301 W12302 W12303 W12304 W12305 W12307   dim_sachkonto counter name position text bez 1 name1 W1230...
Need Help
  • Samarth_18's avatar
    Samarth_18
    5 years ago

    Hi lboldrino 

     

    You can create a column with below code

     

    Column = 
CALCULATE(FIRSTNONBLANK(fact_fahrzeuge[kennzeichen],1),
FILTER(ALL(fact_fahrzeuge),CONTAINSSTRING(dim_sachkonto[bez],fact_fahrzeuge[kennzeichen]) || 
CONTAINSSTRING(dim_sachkonto[position],fact_fahrzeuge[kennzeichen]) ||
CONTAINSSTRING(dim_sachkonto[text],fact_fahrzeuge[kennzeichen])))

     

     

    Note:- W12305 it is not coming for me because its copied as  W!2305 in my data table. But it will works for you 🙂

    Thanks

Samarth_18's avatar
Samarth_18
Icon for Community Champion rankCommunity Champion
5 years ago

Hi lboldrino 

 

You can create a column with below code

 

Column = 
CALCULATE(FIRSTNONBLANK(fact_fahrzeuge[kennzeichen],1),
FILTER(ALL(fact_fahrzeuge),CONTAINSSTRING(dim_sachkonto[bez],fact_fahrzeuge[kennzeichen]) || 
CONTAINSSTRING(dim_sachkonto[position],fact_fahrzeuge[kennzeichen]) ||
CONTAINSSTRING(dim_sachkonto[text],fact_fahrzeuge[kennzeichen])))

 

 

Note:- W12305 it is not coming for me because its copied as  W!2305 in my data table. But it will works for you 🙂

Thanks