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", "")

15 Replies

  • parry2k's avatar
    parry2k
    Super User
    7 years ago

    Anonymous I guess your table name id Date and your column name is also Date, correct?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

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

      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

       

      • parry2k's avatar
        parry2k
        Super User
        7 years ago

        Anonymous how you are adding date column?