Forum Discussion

lherbert501's avatar
lherbert501
Post Prodigy
2 years ago
Solved

Dax Logic

Hi,   Could somebody please help me with some Dax?   Location 1 and Location 2 are theorietically the same thing but are in my system twice and I need to say, if the qty column is greater than 0 ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi lherbert501 

    You can refer to the following solution.

    The sample data is the same as yours

    1.Create a rank column

    Rank =
RANKX (
    FILTER (
        'Table',
        [Item] = EARLIER ( 'Table'[Item] )
            && [Date] = EARLIER ( 'Table'[Date] )
            && [Country] = EARLIER ( 'Table'[Country] )
    ),
    [Location],
    ,
    ASC
)

    2.Create a result column

    Result = IF([Rank]=1,[Qty])

    Output

     

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Ahmedx's avatar
Ahmedx
Super User
2 years ago

look carefully, this is what you are looking for

lherbert501's avatar
lherbert501
Post Prodigy
2 years ago

Ahmedx  Thanks for your reply.

 

Could you please explain a bit more?

 

Thanks

  • Ahmedx's avatar
    Ahmedx
    Super User
    2 years ago

    should I explain it or should you
    I just wanted to reproduce your logic if I understood correctly
    added a new column and there should be the word priority

    • lherbert501's avatar
      lherbert501
      Post Prodigy
      2 years ago

      I need something like 

       

      If Location =' Location 1' and item,date and country match to location 2's  (so it already exists for the other location) then take quantity from location 1, else location 2. 

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi lherbert501 

        You can refer to the following solution.

        The sample data is the same as yours

        1.Create a rank column

        Rank =
RANKX (
    FILTER (
        'Table',
        [Item] = EARLIER ( 'Table'[Item] )
            && [Date] = EARLIER ( 'Table'[Date] )
            && [Country] = EARLIER ( 'Table'[Country] )
    ),
    [Location],
    ,
    ASC
)

        2.Create a result column

        Result = IF([Rank]=1,[Qty])

        Output

         

        Best Regards!

        Yolo Zhu

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.