Datatable

[AtchayaP]

My original date year starts from 2014 but after adding data table I got from 1899 which is wrong year , how can I change it?

 

 

[Anonymous]

Hi  @AtchayaP ,

Generally, the year is incorrectly recognized, resulting in only the data format of the month and day.

You can change its date format to "yyyy-mm-dd" in the data source, or when importing into Power BI, Select "Transform Data", go to Power Query and change its date format to Date/Time date format.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PaulDBrown]

Try:

Date Table =
ADDCOLUMNS (
    CALENDAR ( MIN ( Table[Date Created] ), MAX ( Table[Date Created] ) ),
    "MonthNum", MONTH ( [Date] ),
    "Month", FORMAT ( [Date], "MMM" ),
    "Year", YEAR ( [Date] )
)

[Tutu_in_YYC]

What is the DAX syntax for the date table?