Forum Discussion

Kmcdonald's avatar
Kmcdonald
Helper III
4 years ago
Solved

IF Statement between Two Tables

Hi,   I've got two tables, one is my transaction in MYOB and the other freight pick up details. The problem I've got is that, my freight sometimes has more than on order in the consignment and I n...
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, Kmcdonald ;

    You could create a column as follows:

    Column = 
var _1=[SO Number]
return
MAXX(
CALCULATETABLE(
    VALUES('Freight'[Actual Pickup Date]),
    CONTAINSSTRING('Freight'[Sender References],_1))
,[Actual Pickup Date])

    The final output is shown below:

    Or create a measure as follows:

    Measure = 
MAXX(
   CALCULATETABLE(
    VALUES('Freight'[Actual Pickup Date]),
     CONTAINSSTRING('Freight'[Sender References],MAX('MYOB'[SO Number]))),[Actual Pickup Date])

    The final output is shown below:

     

     

    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

Hi, Kmcdonald ;

You could create a column as follows:

Column = 
var _1=[SO Number]
return
MAXX(
CALCULATETABLE(
    VALUES('Freight'[Actual Pickup Date]),
    CONTAINSSTRING('Freight'[Sender References],_1))
,[Actual Pickup Date])

The final output is shown below:

Or create a measure as follows:

Measure = 
MAXX(
   CALCULATETABLE(
    VALUES('Freight'[Actual Pickup Date]),
     CONTAINSSTRING('Freight'[Sender References],MAX('MYOB'[SO Number]))),[Actual Pickup Date])

The final output is shown below:

 

 

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.