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,
I'm new to Power BI and I'm trying to figure out the DAX formula to perform multiplication on each row for two columns (see attached screenshot: Cur_Rate * Curr Amt Fin / 100). I want each row to calculate so it rolls up into an aggregated number. Let me know your thoughts on the formula!
Solved! Go to Solution.
Hi @NCPowerBI ,
Try this measure...😎
New Measure =
VAR A = SUMX('Table A', ('Table A'[Cur Rate] * 'Table A'[Curr Amt Finn]))
VAR B = A / 100
Return B
Here is an example of it working...
Many Thanks,
Taylor
LinkedIn: www.linkedin.com/in/taylordownes10 😊
This worked perfectly, thanks Taylor!
Hi @NCPowerBI ,
Try this measure...😎
New Measure =
VAR A = SUMX('Table A', ('Table A'[Cur Rate] * 'Table A'[Curr Amt Finn]))
VAR B = A / 100
Return B
Here is an example of it working...
Many Thanks,
Taylor
LinkedIn: www.linkedin.com/in/taylordownes10 😊
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 |
---|---|
106 | |
97 | |
80 | |
67 | |
63 |
User | Count |
---|---|
147 | |
110 | |
108 | |
85 | |
64 |