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,
I have balances in 2 currencies; CAD and USD.
I want to convert USD to CAD and achieve the expected result below.
Currency | Total Closing Balance | Current conversion applied to closing | Expected Result |
USD | $34,490,504.28 | $42,488,852.22 | $42,488,852.22 |
CAD | -$26,645,252.30 | -$32,824,286.31 | -$26,645,252.30 |
How would I go about this? I've tried using IF() in a calculated column, but I run into a circular dependency error as I already have a another calculated column (ideally, I'll use a measure for that as well). If I try using IF() as a measure instead, I get the following:
I tried making the IF() function work by creating a conditional column in Power Query, then creating the following measure:
What am I missing?
@DBA1138 - In measures, you need to wrap your column references in an aggregator like MAX, MIN, etc.