Forum Discussion
Solved
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 MVenables 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
Hi MVenables 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