Compare Monthly report PowerBi desktop

[FGaxha]

Hi, need help ?
I have to download data from web platform monthly:
I download March report then in April I downloaded April report. How to compare values from tableMarch with tableApril.
Both tables having same header format and multiple column. Total 15 column.
I need to compare tableMarch column15 with table April column 15.
Both tables contains 40k rows.
Key table will be “Product Id” if key table is needed?
Thanks you?

 

[JEC]

Just put the values in a table or matrix to see differences

 

[FGaxha]

How do i me many to many connection . It will be every month downloaded reports. I would like te me the download table dynamic.

 

[Gaurav07]

You can check this solution. i think it will help you.

1. Import both tables into Power BI and ensure that the data is formatted correctly.
2. Create a relationship between the two tables based on the "Product Id" column.
3. Create a new measure to calculate the difference between column 15 in the two tables. To do this, you can use the "SUMX" function to sum up the values in each table and then subtract the April total from the March total.
   • The formula for the measure could look something like this: Measure = SUMX(TableMarch, TableMarch[Column15]) - SUMX(TableApril, TableApril[Column15])
4. Create a table or chart that displays the "Product Id" column and the new measure you just created. This will show you which products have changed from March to April and by how much.

 

[FGaxha]

You can check this solution. i think it will help you.

1. Import both tables into Power BI and ensure that the data is formatted correctly.
2. Create a relationship between the two tables based on the "Product Id" column.
3. Create a new measure to calculate the difference between column 15 in the two tables. To do this, you can use the "SUMX" function to sum up the values in each table and then subtract the April total from the March total.
   • The formula for the measure could look something like this: Measure = SUMX(TableMarch, TableMarch[Column15]) - SUMX(TableApril, TableApril[Column15])
4. Create a table or chart that displays the "Product Id" column and the new measure you just created. This will show you which products have changed from March to April and by how much.

Thanks you.
It works great