Forum Discussion

learn2learn's avatar
learn2learn
Regular Visitor
5 years ago
Solved

Finding Shipment IDs that do not match

Hi, I am new to powerbi, please help. I have a data that is structured like this:    I wanted to find the ShipmentID's were import and export do not equal.  Thank You!!!! 
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    5 years ago

    learn2learn . Create a new column like

     


    new column =
    var _imp = sumx(filter(Table, [shipmentID] =earlier([shipmentID]) && [Direction] ="Import"),[Weight])
    var _exp = sumx(filter(Table, [shipmentID] =earlier([shipmentID]) && [Direction] ="Export"),[Weight])
    return
    if( _imp = _exp , True(), false())

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

learn2learn . Create a new column like

 


new column =
var _imp = sumx(filter(Table, [shipmentID] =earlier([shipmentID]) && [Direction] ="Import"),[Weight])
var _exp = sumx(filter(Table, [shipmentID] =earlier([shipmentID]) && [Direction] ="Export"),[Weight])
return
if( _imp = _exp , True(), false())

learn2learn's avatar
learn2learn
Regular Visitor
5 years ago

Thank you so much!!!