Forum Discussion

Lumegu's avatar
Lumegu
Frequent Visitor
4 years ago
Solved

Obtain date from different table

Dear community,   I have the following issue for which I hope one of you could perhaps help me out:   There are two data sets: 1. Contains items: Item Status item Due date activity B (to b...
  • smpa01's avatar
    smpa01
    4 years ago

    Lumegu  try this measure

    Measure = CALCULATE(MAX('Table 2'[Due date activity]),FILTER('Table 2','Table 2'[Activity]="B"))

     

     

VahidDM's avatar
VahidDM
Icon for Super User rankSuper User
4 years ago

Hi Lumegu 

 

If you want to add a column to your table 1, try this code to add a calculated column:

 

Due date activity B =
CALCULATE (
    MAX ( 'Table 2'[Due date activity] ),
    FILTER (
        'Table 2',
        'Table 2'[Activity] = "B"
            && 'Table 2'[Item] = EARLIER ( 'Table'[Item] )
    )
)

 

output:

 

 

 

if you want a measure, use smpa01  solution.

 

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/