Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Adding columns from related table

I have two table “Document Register” & Workflow”.  What I want is   IF Document Number and Rev(columns) in document register table is matching with document number and Rev(columns) in workflow tabl...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    hi Anonymous 

    First, Revision from document table and Revision table from WF table are different data type, you need to keep them same data type.

     

    Second, both tables are related with one to Many relationship, for document Number and Revision from document table = Document Number & Revision table from WF table, it may have one or more date value(Date due, Date finished) from WF table for each document Number and Revision, so just try this formula logic as mwegener: 

    Completed Date = MAXX(FILTER(RELATEDTABLE(WF), WF[Revision] = 'aconex vw_Document'[Revision]),WF[Date due])

     

    Regards,

    Lin

  • mwegener's avatar
    mwegener
    6 years ago

    Hi Anonymous ,

     

    did you solve your problem?


    If I answered your question, please mark my post as solution, this will also help others.

    Please give Kudos for support.

mwegener's avatar
mwegener
Most Valuable Professional
6 years ago

Hi Anonymous ,

 

could you share a sample PBIX File?

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Shared using dropbox

  • mwegener's avatar
    mwegener
    Most Valuable Professional
    6 years ago

    The URL is missing.

      • mwegener's avatar
        mwegener
        Most Valuable Professional
        6 years ago

        Hi  Anonymous .

        did I understand you correctly that you want to put the column from the WF table into the document table?

        Like this?

         

         

        Completed Date = MAXX(RELATEDTABLE(WF),WF[Completed Date])

         

         

        If I answered your question, please mark my post as solution, this will also help others.

        Please give Kudos for support.