The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Hi,
I am trying to perform multiplication on two columns on a huge dataset. Which formula should I use for multiplication?
Solved! Go to Solution.
Hi @Anonymous ,
You can try as a measure
Multiply = SUMX(YourTableName,YourTableName[Column1] * YourTableName[Column2])
or in a table
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
Proud to be a Super User!
Hi @Anonymous ,
You can try as a measure
Multiply = SUMX(YourTableName,YourTableName[Column1] * YourTableName[Column2])
or in a table
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
Proud to be a Super User!
Hi @Anonymous
Your question isn't really clear about what you want to do. In DAX and Power Query you multiply by using the * operator.
Maybe if you supply some more detail and sample data I can give you a better answer.
Phil
If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.
Proud to be a Super User!