Need help in compare selected file with history files

[munirathnam]

Hi All,

Need you tips and tricks to achieve the below requirement.

I have HR Data for 5Months.

1. If a user select any month from slicer, need to compare the selected month file with history files (with any selected files).

Thanks in advance!

Thanks,

Muni.

[v-lionel-msft · Accepted solution]

Hi @munirathnam ,

Please refer to my .pbix file.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@munirathnam , refer if these two can help

https://community.powerbi.com/t5/Desktop/Retain-file-name-column-when-using-Folder-as-a-data-source-...

https://www.sqlservercentral.com/blogs/include-file-name-in-content-using-power-query

[amitchandak]

@munirathnam , can you share the data structure, How history files are loaded in power bi.

[munirathnam]

@amitchandak, Thanks for your time.

I have files in one folder, i selected Folder in Get Data and provided the path then loaded. All files loaded into desktop.

We have filename column, where we can file for particular file. (file name: abed_IT202012_IT.xlsx)

Thanks,

Muni.

[v-lionel-msft]

Hi @munirathnam ,

Is it liek this? What is your expected output?

Is this what you want?

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[munirathnam]

Hi v-lionel-msft,

Thanks for you time!

No,I want to Compare current file with selected file (previous months) Line by Line.

Hope you got the requirement.

Best Regards,

Muni.