Forum Discussion
Filtering by Financial Year
I am trying to create a new column with financial year, i tried the following but it had the following error. Can anyone advice me. Thanks so much in advance.
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", "")
Hey Anonymous
The date column isn't displayed in your screenshot; maybe that column isn't formatted correctly?
The other screenshot doesn't show the full expression, but the contents of your IF statements displayed in the screenshot look to be formatted properly.
Anonymous parry2k
The date column is showing error.
I am not sure about the data table id, only added a new column for the financial date ("date")
Is there anything else i need to do prior to this step?
Thanks so much in advance