Forum Discussion
JMHickman1987
4 years agoRegular Visitor
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...
- 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
amitchandak
4 years agoSuper User
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