Forum Discussion

dpbi's avatar
dpbi
Icon for Helper I rankHelper I
9 years ago
Solved

Format Date and Time

I have Excel file with date column ('Column1') format as:  dd/mm/yy   and time column ('Column2') format as: hh/mm.   I need to use these columns in a chart with a new calculated datetime column (...
Need Help
  • MFelix's avatar
    MFelix
    9 years ago
    Hi dpbi,

    On the PBI on the modelling tab you can choose the formst of the date and other fields so.you can select the order of day month and year.

    If you want a dax formula you can use:

    Date = Format(Table ['Column1'] + Table ['Column2'] ,"dd/mm/yy")

    Regards,
    MFelix
DominikPetri's avatar
DominikPetri
Icon for Advocate V rankAdvocate V
9 years ago

Try

DateTime.ToText([YourDateTimeColumn],"dd/MM/yyyy")

 

Hope this helps

Dominik.