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 avail...
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.