How do I create a column that combines columns containing Hour, Day, Week, Month, Year data?

[JMHickman1987]

Hello Microsoft Power BI Community,

First post and new to Power BI. 

I am currently creating a Power BI visualization that uses a sharepoint excel sheet as a database. The excel sheet contains several courses across the European Union and has a myriad of different course duration ranges. The courses range from single day certifications to PhD length degrees. One of the fields that is a part of the visualization is the course duration. The course duration ranges from hours, days, weeks, months and years. I have seperated the excel sheet into those different increments and organized the rows by course title. 

I am trying to create a new column that combines the course duration. As some courses have durations like of 56 days, I am having to calculate and seperate how many months/weeks/days that would be. As such, we have 5 columns with different time increments. These columns include hour, day, week, month and year. 

Is there a way that I create a column that combines these 5 columns into something that reads like 2 months, 1 weeks 15 days within Power BI? 

If you guys need any more information, please do not hesitate to ask.

[amitchandak · Accepted solution]

@JMHickman1987 , You can have text column, that will not add up

example

new column

[Col1] & "Months" & [Col2] & "Days" & [Col3] & "Hours"

you can add if to handle null, 0 value