Forum Discussion
linked purchased order table not showing correct data
Super UserHi! Right now it looks like the visual that you have on your canvas for selecting a year is a table visual instead of a slicer. For the order quantity it looks like it is displaying a count, but I am assuming you want a sum. Check to make sure the field that has your quantity ordered is set to whole number and not text. Then, create a measure of Quantity Ordered = SUM ('YourTable'[YourFieldName])
Hi there! The issue I'm having right now is that when I linked products to Purchase orders using the internal reference no.,
I'm getting this message:
I need to link Products to Purchase Orders so I can extract the products purchased in a Purchase Order.
I think this will not follow the standard Star schema as I also need to link products in POS Orders table to extract the Products Sold. This will create ambiguity right? Any other input on this? Thanks in advance.