Forum Discussion

cyborgandy's avatar
cyborgandy
Icon for Helper II rankHelper II
2 years ago

Hi Ahmedx , thanks for your help, issue is in my dataset I also have same value in positive, for example for company ABC i have 3 entries of same amount , 2 of them are in positive and 1 in negative, after this dax its giving matched for positive values , however I want the matched for same negative value with postive value

Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
2 years ago

did you try this variant?

  • cyborgandy's avatar
    cyborgandy
    Icon for Helper II rankHelper II
    2 years ago

    Hey @Ahmedx , I tried the above solution, but the issue is , suppose for ABC company for Jan if i have 3 entries of 5000, 2 of them are +5000 and one of them are -5000, its giving matched for +5000 only, I want one -5000 and one +5000 to show as matched