Power BI
Power BI
(OP)
Hi
Does anyone know if there is a forum for Power BI Desktop I have a couple of questions that I could do with some help with
1. How do you sum Time fields hh:mm:ss
2. How do I concatenate a text field and a date field together. I know where to join 2 columns but I cannot get the syntax correct.
This is probably not the right Forum but if someone could point me to the right place please.
Thanks in advance
Does anyone know if there is a forum for Power BI Desktop I have a couple of questions that I could do with some help with
1. How do you sum Time fields hh:mm:ss
2. How do I concatenate a text field and a date field together. I know where to join 2 columns but I cannot get the syntax correct.
This is probably not the right Forum but if someone could point me to the right place please.
Thanks in advance
RE: Power BI
1. How do you sum Time fields hh:mm:ss
You would only sum Time fields if at least one of them were a Time Duration field. You simply sum them and then FORMAT the result to suite your needs as you would any Date/Time value.
FAQ68-5827: Understanding Dates and Times & why they seem to be so much trouble?
2. How do I concatenate a text field and a date field
Since Date/Time values are numbers, you must convert your Date/Time value FORMAT using the TEXT() function as...
=TextFieldRef&TEXT(Date/TimeRef,"yyyy/mm/dd")
Skip,
for a NUance!
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein
RE: Power BI
Most of the code are recorded steps.
combo