Events in Progress used for Resource Loading Calcs

[BrianJ]

@Melissa ,

Great solution. Very weird to see two DAX NATURALLEFTOUTERJOIN lineage break solutions in the same week. That’s one that I keep in Analyst Hub because it comes up so seldom, at least for me…

Dynamic table with join

@Roberto , I think this will work well for you. You can use DAX NATURALLEFTOUTERJOIN, but first you need to break the lineage with SELECTCOLUMNS. Combined = VAR vTable1 = SELECTCOLUMNS( 'SubRegions', "Region", 'SubRegions'[RegionName] & "", "Subregion", 'SubRegions'[SubRegion] ) VAR vTable2 = SELECTCOLUMNS( 'RegionsWithSortCode', "Region", 'RegionsWithSortCode'[RegionName] & "", "Sort", 'RegionsWithSortCode'[Sort] ) RETURN NA…

• Brian