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.