Forum Discussion

Switto's avatar
Switto
Helper IV
6 years ago
Solved

if condition between two tables

Hello Everyone,   I am working on Time and Motion data which requires excluding the line items which are not aligned to Project TAT.   So I have a table which has data for day to day line items w...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    Switto - You will want to use RELATED or RELATEDTABLE or possibly LOOKUPVALUE and could also use MAXX(FILTER(...)...)

Switto's avatar
Switto
Helper IV
6 years ago
Thanks Ankit for the note, however it has confidential data hence unable to share it. Appreciate you quick reply. Thanks
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Switto 

    For such multiple tables senario, you can create a short sample with random data to describe your model, you are unlikely to get an expected solution without a sample pbix.

     

    Regards
    Paul