Forum Discussion

watje255_ju's avatar
watje255_ju
Icon for Helper III rankHelper III
3 years ago
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...
  • rautaniket0077's avatar
    rautaniket0077
    3 years ago

    Hi watje255_ju ,

     

    Try replacing date from dimdate with date from factsales and format it as "Mmm yyyy"

rautaniket0077's avatar
rautaniket0077
Icon for Resolver I rankResolver I
3 years ago

Hi watje255_ju ,

 

Try replacing date from dimdate with date from factsales and format it as "Mmm yyyy"

watje255_ju's avatar
watje255_ju
Icon for Helper III rankHelper III
3 years ago
Awesome, thanks so much!