Forum Discussion
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 (...
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
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
Solution works!
Thank you very much.
Dominik i will try your solution as well.
Thanks again for both of you.