Forum Discussion

JMHickman1987's avatar
JMHickman1987
Regular Visitor
4 years ago
Solved

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

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.

  • 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

     

     

1 Reply

  • 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