Concatenate multiple columns to get date column

[VenkateshC]

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

 

[Eric_Zhang · Accepted solution]

@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

[Eric_Zhang · Accepted solution]

@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

[VenkateshC · Accepted solution]

Thank you Eric!