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 all,
This is related to if there is a way to multiple value of a measure to a column. I have cost in either euor or pound and I want all of them to be converted into pound. First I have to divide cost by a million and then multiply by currency rate. And I have currency rate coming from database for each row.
If I create currency rate as a measure then results are wrong. So I had to create a calculated column with all of the calulations and then create a measure which is equal to sum(calculated column). But I am looking for a better and effective way to do it.
Sample data and formulas please.
Hi @Anonymous,
Did you mean this?
Measure:
Final Cost = CALCULATE ( MAX ( Tab[cost] ) ) / 1000000 * CALCULATE ( MAX ( Tab[currency_rate] ) )
Thanks,
Xi Jin.
Simple one... hope the solution is marked....
Why did you use MAX in the calculation? When I tried using this formula in my original dataset I din't get the desired results.
Hi @Anonymous,
Because I'm using a measure. Measure cannot call the table column directly.
As you said it didn't work for you. Could you please share us some detailed screenshots about your wrong results?
Thanks,
Xi Jin.
I should be geteing same values a spend column rather I am getting values in final cost
Hi @Anonymous,
Sorry but I don't quite understand about your screenshot and your description.
Sicne the finalcost formula is Adjusted Cost/Currency Rate and the formula of Adjusted Cost is Cost (Spend ?)/1000000. So the final formula shoule be Cost (Spend ?)/1000000/Currency Rate. Right?
Then what does "getting same values as spend column"?
Thanks,
Xi Jin.
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 | |
93 | |
83 | |
70 | |
65 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |