Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
VenkateshC
Frequent Visitor

Concatenate multiple columns to get date column

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

 Column-Concatenate.png

 

2 ACCEPTED SOLUTIONS
Eric_Zhang
Employee
Employee

@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

 Column-Concatenate.png

 

@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

Capture.PNG

View solution in original post

2 REPLIES 2
Eric_Zhang
Employee
Employee

@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

 Column-Concatenate.png

 

@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

Capture.PNG

Thank you Eric!

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.