Forum Discussion
Helper IFiltering a table before Merge?
Hello!
So below are the tables and its contents. What im planning to do is filter the invoice month and branch code of Table A and Table B before inner joining them.
Another good thing is having the Invoice Month and Branch Code on a Visual slicer so I could change them whenever.
This is easy to do in excel but the 900k+ data is just too big and everything just freezes.
Is this possible to do? thanks!!
Table A
Invoice Month
Branch Code
Item ID
Total Item Price
Table B
Invoice Month
Branch Code
Item ID
Total Item Price
Figured it out. I just used a dynamic Filter.
5 Replies
MahyarTFMemorable Member
Not sure, if you are talking about Power BI ?
If yes, in Power Query you could delete the columns before merging the tables, also in Power Bi, you could use the particular columns in the CrossJoin function in calculated table
Appreciate your Kudos and please mark it as a solution if it helps you.
lancerscYes. Boss wants the whole process to be on PowerBI and im having a hard time making it work. Want to take a look at the query?
Why would I delete a column?
Does crossjoin inner join the 2 datas?
- amitchandak
Super User
- lancersc
Figured it out. I just used a dynamic Filter.
