Forum Discussion

Gopinath_iyer's avatar
Gopinath_iyer
Helper II
3 years ago
Solved

comparing two excel files

Hi

 

I have two excel files EMP (has duplicates) and Master (unique rows) but number of columns are not same in both the files.

 

Both data has emp number as common field and I want to find the list of employees present in EMP and not present in Master and vise versa.

Can this be achieved?

 

regards,

Gopi

Need Help
  • Shaurya's avatar
    Shaurya
    3 years ago

    Hi Gopinath_iyer,

     

    You can use the following formulas:

     

    Distinct Emp Count = DISTINCTCOUNT(Emp[ID])

     

    Emp not in Master = [Distinct Emp Count] - CALCULATE(Emp[Distinct Emp Count],FILTER(Emp,Emp[ID] IN VALUES(Master[ID])))

     

    Result:

     

    Works for you? Mark this post as a solution if it does!
    Consider taking a look at my blog: Forecast Period - Graphical Comparison 

1 Reply

  • Shaurya's avatar
    Shaurya
    Memorable Member
    3 years ago

    Hi Gopinath_iyer,

     

    You can use the following formulas:

     

    Distinct Emp Count = DISTINCTCOUNT(Emp[ID])

     

    Emp not in Master = [Distinct Emp Count] - CALCULATE(Emp[Distinct Emp Count],FILTER(Emp,Emp[ID] IN VALUES(Master[ID])))

     

    Result:

     

    Works for you? Mark this post as a solution if it does!
    Consider taking a look at my blog: Forecast Period - Graphical Comparison