Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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.
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    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", "")
Anonymous's avatar
Anonymous
Not applicable
7 years ago

parry2k i added only 1 condition and is the same error "the syntax for [Date1] is incorrect.

parry2k's avatar
parry2k
Super User
7 years ago

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", "")
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    it works! Thank so much! :smileylol:

    parry2k