Forum Discussion

Anonymous

Not applicable

4 years ago

Solved

Conditional Column not appearing in Data view.

Hi all! Hopefully this is an easy one today! I'm sure its not difficult to resolve but I can't find the solution...

I've created a new column of data using Conditional Column in the Power Query editor. I can see all the values and they're working as I want them.

However, when I click "close and apply", I'm unable to locate this new column anywhere in the data view.

Am I missing a step somewhere? I've created columns before without a problem, so not sure if I'm missing something out?

Cheers

Anonymous
Not applicable
4 years ago
Ahh I think I may have sorted it myself. It looks like I've got duplicate tables, and I was looking at the wrong place.
Pragati11
Super User
4 years ago
HI Anonymous ,

Can you share some screenshot around what is the issue?

I did create a custom column in Power BI in Power Query Editor and do see it under Data View after applying the Power Query changes. I created the highlighted columns below in power query editor:

After applying my changes, I see them under Data view:

Are you using latest Power BI Desktop version?

Can you close Power BI and re-do column creation again and check?
- Anonymous
  Not applicable
  4 years ago
  Thanks, I've sorted! For some reason, a duplicate table that I'd deleted in the model view, was still appearing in the data view, and without realising it I was doing the new column in the deleted table....
  
  Not sure why a deleted table was showing up like that but I'm gonna go through and cleanse it all.
  
  Cheers!