Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |