Power BI - Add Custom Column - Date

In Power BI Desktop, if you an Excel with columns of year, month and day, and needed to create a custom date column.

To create this custom date column, here's the formula.

=Text.From([Day]) & "-" &  Text.From([Month]) & "-" & Text.From([Year])


This is different from a hierarchy column where you can just drag and drop.