Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreThe FabCon + SQLCon recap series starts April 14th at 8am Pacific. If you’re tracking where AI is going inside Fabric, this first session is a can't miss. Register now
Dear,
I'm new to DAX.
I'm trying to multiply two columns: quantity and trade price. (the colums are in the same table)
For this I'm using the product formula, but I keep receiving an error that the syntax is incorrect.
Could somebody please help?
Solved! Go to Solution.
Product I think just works across one column and not multiple, does a measure like Sales = [quantity]*[trade price] not work?
@niekdp why not just share your formula instead of letting everybody wild guessing what would be wrong with it?
Next time I will do this, thx!
Product I think just works across one column and not multiple, does a measure like Sales = [quantity]*[trade price] not work?
Yes that should work, if it's in the same table. What error are you getting?
What is the formula you are currently using? What error does it give?
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 53 | |
| 40 | |
| 38 | |
| 19 | |
| 18 |
| User | Count |
|---|---|
| 70 | |
| 69 | |
| 34 | |
| 33 | |
| 30 |