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.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Shared using dropbox

mwegener's avatar
mwegener
Icon for Most Valuable Professional rankMost Valuable Professional
6 years ago

The URL is missing.

    • mwegener's avatar
      mwegener
      Icon for Most Valuable Professional rankMost 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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Yes but based on condition

        If document Number and Revision from document table = Document Number & Revision table from WF table then

        add date columns from WF table to Document table