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 everyone,
I am creating a measure to convert currency. The logic of currency conversion is that if the opportunity has a future close date, then use the most recent exchange rate.
But my measure doesn't show any conversion rate when there is a future close date.
Thanks!
Hi @minmin99 ,
Your formula is too poorly readable, so I suggest you split it into multiple measures and check for problems.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Lookup-Min-Max/td-p/985814
In your case, you are looking up the MAX of the data with appropriate filters.
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 |
---|---|
96 | |
95 | |
82 | |
71 | |
64 |
User | Count |
---|---|
116 | |
106 | |
94 | |
79 | |
72 |