I have the following problem, I am importing an excel file to the data load editor, one of the columns of this file is a date, in this format: DD.MM.YYYY (SellingDate)
I need to extract from that date the MonthYear, so i used this formula: Date(SellingDate, 'MMM YYYY') as MonthYear
Then I go to the sheet to work on my dashboard, and I set a filter for MonthYear, but I get as many MonthYears as rows my dataset has. It is not aggregating correctly. It is taking MonthYear as unique values even tho they are the same.
