Forum Discussion
Helper IIIHelp - 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.
Helper IIIIf 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