Populate column

Hi Anonymous,

I used a multi-step approach:

1. First, I created a new column in dimVehicle table for Total Number of Vehicles:

Total Number of Vehicles = LOOKUPVALUE(FactsVehicle[Total Number of Vehicles], dimVehicle[Vehicle ID], dimVehicle[Vehicle ID])

2. Next, I created a new column Replacement Vehicle ID in FactsVehicle:

Replacement Vehicle ID = LOOKUPVALUE(dimVehicle[Replacement Vehicle ID], dimVehicle[Vehicle ID], FactsVehicle[Vehicle ID])

3. Lastly created a new column for Total Number of Vehicles 2 (You can use this column in the table instead of Total Number of Vehicles)

Total Number of Vehicles 2 = if(ISBLANK(FactsVehicle[Total Number of Vehicles]), LOOKUPVALUE(dimVehicle[Total Number of Vehicles], dimVehicle[Replacement Vehicle ID], FactsVehicle[Vehicle ID]), FactsVehicle[Total Number of Vehicles])

This column uses the Total Number of Vehicles value for replacement ID where there is a NULL value in the original table.

There probably exists a better solution but this should give you the desired outcome.

Hope this helps.