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"))

     

     

smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
4 years ago

Lumegu  try this measure

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