Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Lobs
Helper II
Helper II

Output based on different Columns

Hi,

 

In my table i have a few columns that have different solutions, which was derived from our survey. Is there a way i can capture those solutions into 1 column so i can get their mix?

 

EmployeeSolution 1Solution 2Solution 3Solution 4Chosen Solution
1 x  Solution 2
2  x Solution 3
3x   Solution 1
4   xSolution 4
3 ACCEPTED SOLUTIONS

Hi Greg,

 

i can't, the solutions are calcualted columns based on the employee's different entries in the survey. 

View solution in original post

Fowmy
Super User
Super User

@Lobs 

In Power Query, right click on employee Column, Select Unpivot Other columns,

Fowmy_0-1598031229572.png

Filter VALUE Column  = x and delete VALUE column

Fowmy_2-1598031323979.png

 

Fowmy_3-1598031344464.png

 

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube, LinkedIn

 

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

amitchandak
Super User
Super User

@Lobs , see if this column calculation can work

switch(true(),
not(isblank([Solution 1])), "Solution 1",
not(isblank([Solution 2])), "Solution 2",
not(isblank([Solution 3])), "Solution 3",
"Solution 4")

View solution in original post

6 REPLIES 6
amitchandak
Super User
Super User

@Lobs , see if this column calculation can work

switch(true(),
not(isblank([Solution 1])), "Solution 1",
not(isblank([Solution 2])), "Solution 2",
not(isblank([Solution 3])), "Solution 3",
"Solution 4")

Thank you this worked. I also learned the UnPivot too, which i used on my other table.

Fowmy
Super User
Super User

@Lobs 

In Power Query, right click on employee Column, Select Unpivot Other columns,

Fowmy_0-1598031229572.png

Filter VALUE Column  = x and delete VALUE column

Fowmy_2-1598031323979.png

 

Fowmy_3-1598031344464.png

 

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube, LinkedIn

 

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Thanks, this worked on my other table lol. Appreciate it

Greg_Deckler
Super User
Super User

@Lobs - I would unpivot your Solution columns in Power Query.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Hi Greg,

 

i can't, the solutions are calcualted columns based on the employee's different entries in the survey. 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.