User Profile
p54
New Member
Joined 3 years ago
User Widgets
Contributions
Re: How To Display Multiple Values In One Cell For Conditional Column
Thanks. I'll try it. I'm just wondering why the Power Query application has not provided a simple IF AND THEN solution that will look for, and display, mulitple values. It seems that Power Query can separate multiple values that have already been displayed through a delimiter function. But not the reverse. Or.....there are 42 words that are assigned 42 unique numbers. Perhaps there is a way to display multiple values with a "range" from 1-42, looking for all numbers in the range? Thanks for the solution. I'll try it.4.4KViews0likes0CommentsHow To Display Multiple Values In One Cell For Conditional Column
Power BI Community, I've created a conditional column in Power Query, which assigns a number based on text found in another column. And multiple conditions exist. For example, the word "apple" is assigned 1. The word "tree" is assigned 4. However, only one value shows for each cell. There should be multiple values showing for some cells. As it applies to this example, Apple Tree is found in the referenced column, but only assigning the value of 1 for apple, but not both 1 and 4 for apple tree. How do I show multiple values in one cell, based on the multiple conditions? Thanks.4.5KViews0likes4Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.