Forum Discussion
Filter down Data in a Fact table Power Query
Hi all, I need some help/suggestions please. I have a fact table called Customer Invoice (Which is Imported), but i don't want to load in all the sales data as its not needeed. I only wan...
Hi Anonymous Inner join should work. However, You could also try left outer join, expand only customer code and then filter out null values.
Also, you could create a list of customer code from customer table and based on that list filter fact table.
Hope this helps!!If this solved your problem, please accept it as a solution and a kudos!!
Best Regards,
Shahariar Hafiz
techies
Super User
Super UserHi Anonymous using M code
= Table.SelectRows(CustomerInvoice, each List.Contains(StarCustomer[CustomerCode], [CustomerCode]))