Forum Discussion
Power BI - Formula Error
Hi,
We are getting unexpected result (always 0) when trying to multiplicate an integer value by a decimal value.
Our Power BI Desktop is connected through direct query to an AWS Redshift database.
The scenario looks like this:
We have two tables (Sales and Products)
| SALES | ||
| Order ID | Product ID | Qtd Sales |
| 1 | 1 | 2000 |
| 2 | 2 | 3000 |
| 3 | 2 | 4000 |
| 4 | 1 | 1000 |
| Product | ||
| Product ID | Product Name | Price Per Unit |
| 1 | Milk | 0,0735 |
| 2 | Ice Cream | 0,0531 |
| 3 | Candies | 0,0135 |
Sales and product are related by Product ID column.
Then we are trying to create a new column on that will be the result of multiplication beetwen Qtd Sales and Price Per Unit. The formula looks like this: Billing = Sales[Qtd Sales] * RELATED(Product[Price Per Unit])
One interesting thing about this problem is that when we change the connection from direct to import, everything works fine.
Any suggestion?
Tks all