Hi I'm trying to add the department name to a combo box with quote line Items as the data source.
AddColumns('Quote Line Items',"D", LookUp(Departments,Department = 'Quote Line Items'[@Department]).Name)
Can anyone see why the formula is wrong?
thanks