topic Concatenate multiple columns to get date column in Developer

Concatenate multiple columns to get date column

VenkateshC — Tue, 05 Sep 2017 11:10:28 GMT

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

Re: Concatenate multiple columns to get date column

Eric_Zhang — Wed, 06 Sep 2017 02:40:09 GMT

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

Re: Concatenate multiple columns to get date column

VenkateshC — Wed, 06 Sep 2017 11:55:22 GMT

Thank you Eric!