How to add multiple variables (adapt '&' to return a value)

[finno14]

Good Morning,

I was hoping someone could help me out- I apologise if this is already common knowledge- I could not find it within the forum.

Essentially I need to add multiple variables- however as '&' brings back True/False the variable does not produce a value-- I know the variable works as individually they return the value--

Below are the variables- and in an ideal world- is what id want the formula to do-- 

*Please note I do not have access to the data tab, nor typical calenders functions are not viable*

Any guidance would be great!!

Kind regards,

[v-jingzhang · Accepted solution]

Hi @finno14 

You only need to use one '&' to combine multiple values. For example,

(Wk1-Wk4) & (Wk2-Wk1) & (Wk3-Wk2)

Or if you want to add a delimiter (e.g. comma) between values, you could use

(Wk1-Wk4) & "," & (Wk2-Wk1) & "," & (Wk3-Wk2)

'&' is a text concatenation operator while '&&' is a logic operator.

DAX syntax - DAX | Microsoft Docs

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.

[Tahreem24]

@finno14  What do you want to display in an output?

[amitchandak]

@finno14 , expected output is not clear to me

If you want to multiple you can create like 

(Wk1 -wk2) *(W3-w4)