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.
Not entirely sure how to get there...my goal is to build a visual where I can say, give me everything that impacts "N01", or "S01", etc, like a slicer. The issue I have is that when the data comes thru, it populates in Site 1, Site 2, etc., but not always in the same manner, so I can't assume that all values in Site 1 are "N01", if that makes sense.
My thought was to transform the data from the "Sites" and build a column where if any of the Sites are populated and they equal "N01", then that column is "yes" if not, "no". That way, I can build my visuals based on that data.
Again, I'm a little stumped on this one and willing to try something new to get to end result too. Thanks! Sorry for delay in response, I've been off sick on and off. Thanks!
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.