Concatenate in a Calculated Field?

[cmcreynolds]

Just wondering if there is a way to concatenate two calculated fields into one within PowerPivot's Data Model.

One is SUMX and the other would a percentage relative to that SUMX.

so, if the SUMX was a calculated field and the percentage was, too, would this work?

8WkSummary:= [8WkSum]&" ("&[8WkPerc]&")"

The result would look like:

Program	Program Sum (% to total)
English	16 (85%)

<tbody>
</tbody>

Or have I lost my way again?

 

[anvg]

Hi
Maybe

CONCATENATE("(" & FORMAT([Year count only],"0") & ") - (",FORMAT([Year average only],"0") & ")")

Regards,

 

[cmcreynolds]

I came across CONCATENATEX...would that be helpful in my case?