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"
Hi, thanks for your reply, that is the problem that I am trying to fix, when there is no data in the underlying table for that SKU and Month, I want to pull the average COGS per unit for that SKU, so that there is a COGS value and we can still calculate a gross margin. This happens in the odd occasion because the GL date can be 1 day behind the subledger date or vice versa, thank you!