Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi everyone,
I am getting stuck on trying to figure out how to filter my report a certain way. Below I will explain what I am trying to do, and provide some sample data to do it with. My background is in Architecture so I have much to learn and look forward to learning from this community.
Starting data: (All the data is fabricated at this point as we have just started the collection cycle)
Basically what I am struggling with is how to have an advanced filtering method that allows you to filter by multiple criteria that is found in a matrix of sorts. An example of this is looking at Phases by the various fields to determin if something is needed during that phase. To complicate it even more I need to break it down to servicePhase by phase. (Images Below)
Current data would be Yes / No values in another document
Any thoughts on how to set this up would be very much appriciated!!
Thanks in advance
~Chris
Solved! Go to Solution.
@Anonymous,
You may try Merge Queries (Table.NestedJoin) in Query Editor.
@Anonymous,
You may try Merge Queries (Table.NestedJoin) in Query Editor.