Forum Discussion
Filtering a table based on different columns
Hi EnterThaBoyd
If you add columns you should select all of them except for training dates before unpivot.The updated pbix is attached
If this post helped, please consider Accepting it as the solution to help the other members find it more quickly
Hi EnterThaBoyd
You can apply these steps to achieve the desired goal :
1. unpivot the table from PQ:
2. Rename the columns to the normal names 🙂
3. After closing and applying create a measure :
4. Create the slicer for the training and the wanted table + filter the table by the test measure
Result :
The pbix with the example is attached
If previous post helped, then please consider Accepting it as the solution to help the other members find it more quickly
I love this, but I was just given a change in the data and this no longer works. They added in "Status" (Full/Parttime/Contractor) and "Office" (Accounting, IT, etc).
| Personnel | Status | Office | Training1 | Training2 |
| John Doe | Full-time | IT | 1/1/2024 | 1/2/2023 |
| Jane Doe | Contractor | Accounting | 1/3/2022 | 1/4/2024 |
So now if I try this, I will have 2 random fields that I don't want in the slicer.
Hi EnterThaBoyd
If you add columns you should select all of them except for training dates before unpivot.The updated pbix is attached
If this post helped, please consider Accepting it as the solution to help the other members find it more quickly