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.
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,
Lydia
I 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.