Find the new materials added

Hi Yashh ,

try out the steps below:

To identify the newly added material based on the data from the two files, you can follow these steps:

1. Load the data from both files into Power BI as separate tables. Let's assume you have loaded them as "File1" and "File2" tables.

2. Merge the two tables using the "Append Queries" feature in Power Query.

   a. In Power Query, select the "File1" table and go to the "Home" tab.

   b. Click on "Append Queries" and select "File2" from the options.

   c. Power Query will combine the two tables into a single table.

3. Create a calculated column to identify the newly added material.

   a. In Power Query, select the merged table and go to the "Add Column" tab.

   b. Click on "Custom Column" and provide a column name, such as "Newly Added Material".

   c. In the formula bar, enter the following formula:

4. Newly Added Material = IF(ISBLANK([SAP Number]), "Newly Added", "")
5.  

6. This formula checks if the "SAP Number" column is blank. If it is blank, it assigns the value "Newly Added" to the "Newly Added Material" column; otherwise, it leaves it blank.

7.  

8. Load the merged table with the calculated column into Power BI as a new table.

9.  

10. In your Power BI report, create a table visual and add the "Newly Added Material" column to it.

    This table will display the materials that have been newly added based on the "SAP Number" column. You should see "Newly Added" next to the newly added material's row in the table visual.

Hello Anonymous 

Thhe files cannot be seperated in the diffent tables as it needs to be done everyday and also needs to have every revision in it.

BR
Yashh