Forum Discussion

DimD's avatar
DimD
Frequent Visitor
4 years ago
Solved

Compare lines between excel files wiht Power BI

Hello community, I hope you are well. I have a small question. I have two excel files that you will find attached. And I'm looking to compare them and know: -the one that is no longer present -...
  • DimD's avatar
    4 years ago

    Hello, 

    I  found solution. Not the best one but it works for me. 

    Will works on it later to improve the solution. 

    - I put all files in a folder and I choose it as source

    - I create a date table. the relationship is inactive, because I have some issue --> Continue to work on it

    - Create several values (is added values, is deleted value, Is in current file, is in previous, is modified, is using relationship) here is a sample of measure

    Then I make measure who count row 

    added, deleted, current .. like this

     

    Use measure as filters and I have my solution

     

    Thank you for your help.