Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

JOIN to another table based on condition

Hi,   I have a dataset in Power BI with Policy Number, Flag and Program Code i.e. 3 separate columns.   There is another excel table with columns Flag, Policy No/Program Code and other attributes...
Need Help
Show and Tell
Tips and Tricks
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

You can populate a column in one table using another table. Only this is you need to use aggregate functions 

 

Refer

Max Sales order id = Maxx(filter(sales,Sales[item_id]='Item'[Item ID]),Sales[Order Id]) 
Max customer = MAXX(filter(Sales,Sales[Order Id]='Item'[Max Sales order id] && Sales[item_id]='Item'[Item ID]),Sales[Customer ID])

 

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 - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601