Lookup column and transform

[Anonymous]

Hello Everyone,

I have following the two tables and columns:

Table A - Mat, Cust

Table B- Cust, Cond

I added a new column in table A to get Cond from table B by using lookup value. I need to transform or add conditional column in table A based on cond and mat. Now when I am opening my power query to transform I am unable to see the column Cond from table B. Is there any easy way to acheive this goal.

Thanks in advance for the help.

[PaulDBrown]

@Anonymous 

Can you explain why you need to populate the table with the conditional columns? In other words, what are you trying to achieve as your final output? (A sample dataset and visual example would help immensely!)
Can you not create a dimension table for "cust" linking both tables and use that for calculations, filters, slicers etc?

[Anonymous]

Thanks for the response. Can you please share how I can build a dimension table?

[v-easonf-msft]

Hi , @Anonymous 

Without more details, it is difficult to solve your issue.

A dimension table always  re-consuming particular columns from each of other tables.

In your case, does your model only contain  two tables?

If so, there is no need to create  a  dimension table.You just need to ensure that the relationship between the two tables is correct.

You  also can  try to use Summmarize   function to  return a summary table. Then add  conditional column by creating  calculated columns.

Best Regards,
Community Support Team _ Eason

[amitchandak]

@Anonymous , In power query you can try merge

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

in Dax - New column in Table A

Maxx(filter(TableB, TableA[Cust] = tableB[Cust]),TableB[Cond]))

Sumx(filter(TableB, TableA[Cust] = tableB[Cust]),TableB[Cond]))

[Pragati11]

Hi @Anonymous ,

There are 2 ways of creating column in POwer BI:

1. Adding columns using DAX expression like you did using LOOKUPVALUE function. This column creation is done in front-end of Power BI, therefore it is not visible in Query Editor.
2. Adding custom columns in Query Editor (backend of Power BI.

Since you created column not in Query editor, therefore you don't see it there.

Thanks,

Pragati