what is the purpose of use MAX for expression ?

[Anonymous]

Hi All

Measure = SUM('TABLE7'[FOREIGN AMT])*MAX('RATE'[EXCHANGE RATE])

[Megha166]

I read your previous Post. Looks like you don't need to use aggregated function MAX with EXCHANGE RATE.  Simply USE below:

Measure = SUM('TABLE7'[FOREIGN AMT])*'RATE'[EXCHANGE RATE])

[Anonymous]

Hi Sir

once i remove max , it does not work.

[Megha166]

Do you have to make it as a Measure Only? I think it should be created as a calculated Column rather than Measure.

[Anonymous]

Hello

I try to use column , and with MAX no error , but result every row same value  ,if i remove MAX  it got error Below :-

[Anonymous · Accepted solution]

MAX function returns the largest value in a column.

In your scenerio, it would return the maxium value of exchange rate from rate table.

Appreciate your kudos!! Mark this post as solution if this helps.