cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mccullm Frequent Visitor
Frequent Visitor

Custom conditional Column from separate list of data

Hi

 

In powerbi I have a query with 2000 rows of data. Within that data i have a column called equipment type. There are over 225 different equipment labels, I am trying to create a custom column that will add a category to the rows. I have 6 categories and would like to make a condition column that inquires into a separate list of categories by referencing the query so that the equipment can be updated easily. I currently have 6 seperate list of the data groups with the peices of equipment that belongs to each categories. Is this possible.

2 REPLIES 2
Community Support Team
Community Support Team

Re: Custom conditional Column from separate list of data

Hi @mccullm,

 

I made one sample for your reference. If it doesn't meet your requirement, Kindly share your pbix to me.

 

1. Create relationship between two tables.

 

Capture.PNG

 

2. Create a calculated column in the target table.

 

category1 = RELATED(Table2[category])

 

2.PNG

 

For more details, please check the pbix as attached.

 

Regards,

Frank

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

Re: Custom conditional Column from separate list of data

Hi @mccullm,

 

Does that make sense? If so, kindly mark my answer as a solution to close the case.


Regards,
Frank

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

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 284 members 3,076 guests
Please welcome our newest community members: