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,
I am trying to make a new column for my dataset. Below is a basic representation of my data.
In column C (ready to go home) I want to say that if all animals of the same type have been chipped then they are ready to go home. (i.e. for each distinct value in column A, I want to evaluate whether all values in column B = "Yes", if so return "Yes" in column C)
In this case, one dog has not been chipped and so dog is not ready to go home. All cats have been chipped and so can be moved home.
Animal | Chipped? | Ready to go home? |
Dog | Yes | No |
Dog | Yes | No |
Dog | No | No |
Cat | Yes | Yes |
Cat | Yes | Yes |
Thanks in advance
Solved! Go to Solution.
Thank you!!!
If I make a new table with the distinct animals in, is there a way I can tidy up the results and just have a single line with yes/no for each animal?
Animal | Ready to go home |
Dog | No |
Cat | Yes |
you can just plot it with animal and the ready to go home column
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.