Forum Discussion
dpbi
Helper I
Helper IFormat 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 (...
MFelix
Super User
Super UserHi 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
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
dpbiSolution works!
Thank you very much.
Dominik i will try your solution as well.
Thanks again for both of you.