Forum Discussion

Alirezam's avatar
Alirezam
Helper V
6 years ago

Replacing multiple valuse in Query

Hi mates, I have 2 tables. I want to replace one column's values with the second table. According to the photo attached, I want to replace 1 with a, 2 with b, 3 with c, so on. I know I can do it wi...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

Based on data share I am not sure what columns are common in two table.  But you can always get values from one table to another using x function like

New column in Table 1 = maxx(filter(table2,table1[customer] = table2[customer] && table2[option]="construction",table2[value])

New column in Table 1 = maxx(filter(table2,table1[Attribute] = table2[name] && table1[project] = table2[project]),table2[name])

Condition may vary, minx, countx, sumx can also be used.

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin

  • Alirezam's avatar
    Alirezam
    Helper V
    6 years ago

    Thanks Amit, I simply want to replace the left yellow comlumn with the second yellow column. They are in 2 different tables.

    • vivran22's avatar
      vivran22
      Community Champion
      6 years ago

      Hello Alirezam,

       

      Has your problem got resolved?

       

      Regards,
      Vivek

      If it helps, please mark it as a solution

      Kudos would be a cherry on the top 🙂

      https://www.vivran.in/