Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Hi @Anonymous
did you try quick measure option to multiple both these fields?
Thnaks,
Tejaswi
Hi @Anonymous ,
Yes, I tried it.
It still returns zero for everything.
That sounds like a bug.
Tks