CODEWITHSUNDEEP
powerbidax
vikaskumawat80
vikaskumawat80

Reputation: 131

Can someone explain me this DAX Expression?

Daily Reimbursement Rates =
CALCULATE (
    CONCATENATEX (
        VALUES ( f_Census[DailyReimbursement] ),
        FORMAT ( f_Census[DailyReimbursement], "$0.00" ),
        ", "
    )
)

Upvotes: 0

Views: 50

Answers (1)

OscarLar
OscarLar

Reputation: 1335

It will take all values in [DailyReimbursment] format it so that the value is in USD with 2 decimals and concatenate them with ", " in-between.

Table:

enter image description here

Measure:

Rate = 
CALCULATE(
    CONCATENATEX(
        VALUES(Data[Value]);
        FORMAT('Data'[Value]; "$0.00");
        ", "
    )
)

Result:

enter image description here

Read more about CONCATENATEX here: MicrosoftDocs

Upvotes: 1

Related Questions