Forum Discussion
Filtering on a value that is not currently present
Hi Garry030424
This is a standard merge tables functionality in PQ :https://learn.microsoft.com/en-us/power-query/merge-queries-overview
Or even just creating a relationship between the table of "transactions" with the reference table that can be used as a filtering table:
https://learn.microsoft.com/en-us/power-bi/guidance/star-schema
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Thanks Ritaf1983 , could you please suggest how this merging is done or any sample reference or something ?
Super UserHi Garry030424
This is a standard merge tables functionality in PQ :
https://learn.microsoft.com/en-us/power-query/merge-queries-overview
Or even just creating a relationship between the table of "transactions" with the reference table that can be used as a filtering table:
https://learn.microsoft.com/en-us/power-bi/guidance/star-schema
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly