Forum Discussion
Graph with multiple series
Context I have two tables. I use table 2 to divide the value by the quantity. Table 1 Column Names Ref Code Food ? Class Category Header Category Value Year Source Test k00022 C...
Hi Dashmir ，
Create a column as below:
quantity = LOOKUPVALUE('Table (2)'[Quantity],'Table (2)'[Code],'Table'[Code],0)And you will see:
For the related .pbix file,pls see attached.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!