Forum Discussion
Dynamic filtering to create multiple columns
I have a set of data (Table 1) that looks like this: I have another table (Table 2) that looks like this: 1. The codes in the "Type A" and "Type B" columns of Table 2 correspond ...
HI Anonymous
I would unpivot the table 2 on column 2,3 and 4 instead of creating three seperate tables so that my DAX formula becomes easier to manage. Also, if you have 50 other table you may consider using one column at the begining which says the table number.
Anonymous Thank you very much for taking the time to respond, however this isn't what I was looking for! 🙂