Forum Discussion

Gopinath_iyer's avatar
Gopinath_iyer
Icon for Helper II rankHelper 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 l...
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 

Shaurya's avatar
Shaurya
Icon for Memorable Member rankMemorable 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