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...
  • amitchandak's avatar
    4 years ago

    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