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.

Comments (0)

Skip to main content