Forum Discussion
Compare lines between excel files wiht Power BI
- 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.
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.