Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Calculated column based on slicer

Hi,

I have one table of NZD revenues and another table of NZD/USD exchange rates.

I want to create a calculated column for USD revenues from a filtered NZD/USD exchange rate.

I.e. I set my slicer to 0.50 for the exchange rate, and my NZD revenue of 1.00 becomes USD revenue of 0.5 in the calcualted column.


Thanks,
Tom. 

 

 

Need Help

1 Reply

  • tarunsingla's avatar
    tarunsingla
    Solution Sage
    7 years ago

    Calculated columns do not support dynamic values (like from What If parameters). You would need a calculated measure instead.