Forum Discussion
Help - Quirky Data
Want to give you an update; I was able to solve this after I explained to you what I wanted. Essentially, I created four Conditional Columns; I set 4 IF statements to pick up the area (to display a True) and then ELSE False. I did one column at a time and essentially got exactly what I needed. Thanks again; your questions prompted me to think about the problem differently.
New2PowerBI,
How do you relate the highlighted values from the second table to the first table? In other works, which logic you use to determine if the highlighted values are yes or no in the second table?
Regards,
Lydia
If any of the Sites, Site1-4, had the value, I would want that value to tie to that new column, i.e., if Site 1 said N01, then I would expect a "True or Yes" value in N01 column. The hard part, for me, is that the value can exist in any of the four columns, Sites1-4. Does that help?
New2PowerBI ,
Sorry for that I miss the image in my second reply. I edit it, please review the image.
Regards,
LydiaI think I understand your question and my reply is the same.
I want Power BI to look at ALL Site1 column values and IF there is a site, let's say, "N01", then I want it to put "Yes" in a new column I create called "N01".
I would want the same logic for the remainder of the sites. Hope this helps. Thanks again for your time and patience.
Want to give you an update; I was able to solve this after I explained to you what I wanted. Essentially, I created four Conditional Columns; I set 4 IF statements to pick up the area (to display a True) and then ELSE False. I did one column at a time and essentially got exactly what I needed. Thanks again; your questions prompted me to think about the problem differently.