Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Calculated columns do not support dynamic values (like from What If parameters). You would need a calculated measure instead.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
78 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |