Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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
@BI-ter
=calculate(divide(Table[Column1],Table[Column2],0),
(Table[fx]))