Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Power Bi community
I have a table with many forms where questions can be answered.
It haves a colum called object_id (can be multiples but I only want one)
It also has a colum called accepted (which can be true or false)
And there are also other less important colums for this task.
I only want one row for each diffrent object_id. So remove duplicate should work, but if one or more of the row has the value true() in the accepted column then I want that one to be included.
I tried to sort the accepted colums first by true or false but it didn't seem to solve the issue.
Any ideas of what I could try next? All help is greatly appricacted.
Solved! Go to Solution.
Hi @ThomasWeppler, you have few options:
Hi @ThomasWeppler, you have few options:
Hi @dufoq3
Thanks for the answer.
I when with the group by function. I changed "yes" to 1 and "no" 0 I summed it up and this way I could see if yes was selected in one of the object_id thenit would be a number larger than 0. From there it was pretty easy.
Thanks for the help and getting me in the right direction. 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.