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

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? 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    parry2k 

    under modelling->new column.

    thanks in advance

    • parry2k's avatar
      parry2k
      Super User
      7 years ago

      Anonymous then what? what expression you are doing to add date

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        parry2k 

        i added the following into the forumla bar.

        I am not sure if is it correct or it need to be done some other way?

        my end result is i need to have a visual that filter by Financial Year.
        any help & hint is appreicated.