Forum Discussion
Slicer For Material Criteria From Different Columns
Hi All. Hoping I can get some help here. I've looked at different Q&A's for issues like mine but just don't seem to see any answers. I have Material codes that can fall into different categories. I c...
SO the material will appear once per month per resource (could be 2 different resources) would that cause an issue?
darentengmfs
Post Prodigy
Post ProdigyAnonymous
If the same material will appear again every month, you need to create a unique column for it.
Since it appears every month, you could concatenate the Material # with the Date column, which then will give you a unique ID for the primary table. Use that to define the relationship between the primary and duplicated table, with the same Cross Filter Direction = Both.
This way, if Material # 1000ABC has a "Y" in InFillAssembly in January 2020, but on February 2020, it is "N", when you filter InFillAssembly="Y", you will only see data for #1000ABC that's in January.