Hi everyone - very very new PBI user here. I have a problem where I have two datasets that use a common identifier - "PrimaryID."
Dataset 1 has roughly 3 million rows, where each row is a unique point in time for whatever ID it's attached to.
Dataset 2 has only 305,000, and also features multiple instances of the same ID.
There is crossover - the PrimaryID's for the smaller dataset appear in the larger one, and I want to analyze the larger dataset (1) using only ID's that show up in the smaller one (2). The big problem I'm running into is difficulty in managing the "many to many" cardinality of the relationships.
In Excel this would be a simple case of using, say, LOOKUP to create a column that could be used as a filter, but if there's a DAX option, or a PowerQuery option, I can't figure it out.