Forum Discussion
Filtering by Financial Year
I think I know what is going on, your table name need to be in single quote because its name is DAte, try following
Date = IF ( AND ( 'Date'[Date1] >= DATE ( 2015, 4, 1 ), 'Date'[Date1] <= DATE ( 2016, 3, 31 ) ), "FY15", "")
i replaced the date with date1 but it still say "the syntax for '[date1] is incorrect.
my current date1 format is as shown in pic.
not sure where i have gone wrong.
Anonymous lets add a simple expression to make sure it is working, add new column with following expression
Date 2 = Your Table Name[Date1]
Anonymous let's add one if condition in date and see if it works and then add the next add one and so on until you get where the issue is. I'm wondering last value you are return is 0 which should be string like "0" , but I don;t think that is the issue though.
parry2k i added only 1 condition and is the same error "the syntax for [Date1] is incorrect.
I think I know what is going on, your table name need to be in single quote because its name is DAte, try following
Date = IF ( AND ( 'Date'[Date1] >= DATE ( 2015, 4, 1 ), 'Date'[Date1] <= DATE ( 2016, 3, 31 ) ), "FY15", "")