Forum Discussion

Yashh's avatar
Yashh
Icon for Helper II rankHelper II
3 years ago

Find the new materials added

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 ...
Data Protection
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
3 years ago

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.