Concatenate multiple columns to get date column

VenkateshC wrote:

Hi All, 

Good day!

 

I've started working on Power BI since past 2 months. I need some help. 

There is a excel with Date, Month and Year column. This is how I get the excel dump. 

Hence, dataset has 3 columns namely, Date, Month and Year_Temp. (Refer screenshot below)

I need to convert this information to date format (DD/MM/YYYY) to get meaningful reports. How can acheive this?

Thank you,

Venkatesh

 

 

VenkateshC

You can create a calculated column as

newDate = DATE(Table1[year_temp],Table1[month],Table1[date])

and then format it as DD/MM/YYYY

Thank you Eric!