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

    Not Working, Again i want to add columns based on excat match of values in both table

    • 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

        how to share please give me ur email id