Using the latest version of Power BI Desktop (July 2018), when I merge two columns together, the other values don't seem to exist anymore.
For example, I have a column of date time values (e.g. 1/1/2018 12:00:00AM). I add a few columns that extract the month and year of this date time column.
As a result, I get two columns: name of month and year. I then do some formatting actions (extracting characters and uppercase).
I then merge the two columns together. I expect to see a list of MonthYear values (e.g. JAN18, FEB18, etc.). However, I only see 1 MonthYear value instead of what I expected (12 or more) when trying to filter.