Find the new materials added

[Yashh]

Hello @Ahmedx 

I have a small problem with the data

This data is from 2 files which gets updated everyday. In this data table in the last line we have a new SAP number added i.e 123456

I want to have a list where i can have the new added material .

Please help, thanks in advance
BR

Yashh 

[Yashh]

Hello @vs_7 

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 

[vs_7]

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", "")

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.

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

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.