Forum Discussion
Solved
Using ALL filter creates blank rows
COGS TEST HB.pbix link to PBIX file Hello, I have two fact tables, one with all the sales and customer data, and one which I am using to pull the COGS. There is no direct link between the two tabl...
Hi watje255_ju ,
Try replacing date from dimdate with date from factsales and format it as "Mmm yyyy"
Thanks, unfortunately the COGS data and the sales data comes from different systems so there has to be two fact tables. IF there is no data for the month due to timing mistmatch, I want to pull the average COGS for that SKU as we still need to report a GM for that sale. Thanks for your time.
watje255_ju you are on good way to resolve this. take a time