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 table then add columns (Date due, Date finished) from workflow table to Document Register table .

 

Please note both tables are related with one to Many relationship

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.

12 Replies