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.
I have written a formula in Tableau which is this
([Per Unit Price ($)]-[Per Unit Cost ($)])*[Units Sold]
now i want to write in powerbi
can someone show me how to write it in PowerBI
Solved! Go to Solution.
Hi,
It depends if you want to use calculated column or measure. For calculated column just write: test_column = (unit price - unit cost)*Units sold. In case of measure: test_meamure = (sum(unit price) - sum(unit cost))*sum(unit sold).
Hi,
It depends if you want to use calculated column or measure. For calculated column just write: test_column = (unit price - unit cost)*Units sold. In case of measure: test_meamure = (sum(unit price) - sum(unit cost))*sum(unit sold).
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 |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |