Forum Discussion

PBI-Newbie's avatar
PBI-Newbie
Helper I
2 years ago
Solved

add column to query to include missing items (DAX)

I have a query with all GL line items. Some of them are missing the vendor information. I would like to add a column to the query that takes the Accounting Document ID and adds the vendor to all dist...
Need Help
  • vicky_'s avatar
    vicky_
    2 years ago

    Either way you suggested works. If you choose to add a column, then you can use the following DAX:

    Vendor added = CALCULATE(MAX(Table[Vendor ID]), ALLEXCEPT(Table[Accounting Doccument]))
PBI-Newbie's avatar
PBI-Newbie
Helper I
2 years ago

Thanks! vicky_ -I added the company code to the ALLEXCEPT part and it worked like a charm!