Forum Discussion
Conditional join on multiple columns
I have following model, which are imported into my project. I would like to either have COGS field from Stock On Hand into Net Forecast or vice versa, by connecting product and date fiel...
Turns out, simple LOOKUPVALUE was sufficient here.
LOOKUPVALUE('bi NetForecastFile'[$COGS],'bi NetForecastFile'[ConsolidateKey], 'bi StockOnHand'[ConsolidateKey], 'bi NetForecastFile'[Date], 'bi StockOnHand'[Date])