Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Why does the formula Copy of Product = FILTER ( 'Product', 'Product'[Color] = "Red") require them around product?
Solved! Go to Solution.
Because PRODUCT() is a DAX function and therefore a reserved word. Same reason you would have to use single quotes if you wanted to name a table 'Table'.
Proud to be a Super User!
Because PRODUCT() is a DAX function and therefore a reserved word. Same reason you would have to use single quotes if you wanted to name a table 'Table'.
Proud to be a Super User!
ahhh ok. I was wondering why but that makes sense. So it's because those words are functions. Got it.
Thanks!
You could name it Products instead of Product. That would work without quotes.
Proud to be a Super User!
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 38 | |
| 38 | |
| 28 | |
| 27 |
| User | Count |
|---|---|
| 124 | |
| 88 | |
| 73 | |
| 66 | |
| 65 |