New Date column not giving Hierarchy or relative filtering

[pdaly]

Hi All,

Late to the show, 1st time posting but loving Power BI.

I have a report linked to a SQL DB using Import (not direct query)

On one of the tables I added a colum with a DAX calculation:

NewDate = FORMAT(DATE(YEAR(TODAY()), Data[Month], 01), "dd/MM/yyyy")

This displays correct on Data view and on report, but when I try to filter a visual it does not give me a Hierarchy of Year,Qtr,Month,Day etc.
and because of this it is not giving me the option to use relative date filtering.

Is there something i'm missing? as all other DB date fields have the hierarchy and no problem

Thanks in advance,

Paul

[pdaly]

Thanks for the reply @HotChilli 
I removed the FORMAT part of the DAX Calc and set the column as Date and all worked 

cheers

[HotChilli · Accepted solution]

Check the data type of the new column.  FORMAT will make it a text type but you want a date.