Forum Discussion
Measure - to divide value by selected fx
Hello Everyone,
Could you please help me to write a measure, which will use either ACT or PLAN fx rate (based on what I select through some button?) and divide values in local currencty to the table in USD
pptx: https://drive.google.com/file/d/12WEa6i0gjjwU9nI1YV0u-e1q26F4Hang/view?usp=sharing
1 Reply
- Mahesh0016
Super User
BI-ter
=calculate(divide(Table[Column1],Table[Column2],0),ALLEXCEPT(TableName,Table[fx]))
**Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!(Table[fx]))
