Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Select values from different tables based on a condition

Hi everyone, I am new in Power BI so I hope I can explain my issue so I could get some help from the group.  I've searched in many places without much success so far. I have several tables containi...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Thanks Ibendlin,

    I ended up appending all my tables in a big one.  (AP, AR, Fixed Assets, GL,...). 

    thanks.

    M.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

This is something you want to prepare before DAX. In Power Query add a column to the Subledgers tables with the account type, ie "Customer" or "Supplier". Then append these tables. After that you can load the final tables into Power BI and wire them up in the data model.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks Ibendlin,

I ended up appending all my tables in a big one.  (AP, AR, Fixed Assets, GL,...). 

thanks.

M.