Forum Discussion
Problem with Quick Measure and Multiplication
Hello everybody,
I've recently started learning how PBI works, I've been left with the (great) work of the colleague who created all our reports.
I have a report that shows how many items are available in the warehouse.
It takes the some of the data from a source, like the number of the items and their Part Number, and from another source it takes the price of every PN.
At the end I need to have a new column which shows the total price of each PN.
Example, I have 456 Units of PN XXXXXX which costs 0,34€ each, so the new column should show as result 155,04.
The same for every other PN.
When I try to set a "Quick Measure", select the operation, the columns that i want to multiply, it gives me completely wrong values.
This is the resulting formula
What am I doing wrong ?
Thanks for any advice !
Best Regards !
edit: typo
1 Reply
Just to add some informations:
This are the tables from which I retrieve the data
PN Data PN-DATA COSTO/CAD VALUTA 011698-6_0100 10/13/2020 12:00 AM 0011698-6_0100-13/10/2020 00:00:00 41 EUR 011698-7_0000 10/13/2020 12:00 AM 0011698-7_0000-13/10/2020 00:00:00 27 EUR 012142-A_0200 10/17/2018 12:00:00 AM 012142-A_0200-17/10/2018 00:00:00 175 EUR And this is the other table, with the PN (ITMREF_0) and the count of how many PNs we can find in the warehouse.
ITMREF_0 Count 0011698-6_0100 6 011698-7_0000 6 012142-A_0200 1 This table had more values with the same ITMREF_0 (PN), so I used the "Group By" function to have each ITMREF_0 and the total count.
Hope this helps.
