Forum Discussion
Creating a custom column to filter data
Hello. I have a very very large table being imported into my dataflow. i have a lot of columns, but for this post, i will shorten it with less columns Title | Category | Date A | E ...
HI, Thanks for your reply.
I get a Token ',' expected with this.
It highlighting the in
Apologises PPStar
I missed you said query editor
= Table.AddColumn(#"Renamed Columns", "swap", each if [Category] = "E" then "Category A" else if [Category] = "F" then "Category A" else if [Date] >= Date.AddYears(Date.From( DateTimeZone.LocalNow()),-2) then "Category B" else "Exclude")