Hi,
Our daily sales data stored in Excel under the "sales" folder. I am trying to compare "Monday Last week's Sales" with "Monday this week's Sales" based on the date.
I would like to create a new table to achieve my result - What are the item are newly added (unique) from Monday last week sales compare to Monday this week's Sales. I don’t want to change the file reference manually every week. How can I automate these process in Power BI. Can you please advise the best alternative way?
The file name is standard TRPP_EXTRACT, only the date and time will be changed on daily basis. The data contain two headers are item and sales area. The item and sales area can be unique some of the files and some of the files are duplicated/repeated.
Sales Data stored in Excel like this under the Sales folder. (Note: The date not stored in my data (inside the Excel). Date showing only my Excel file).
TRPP_EXTRACT_2020_11_16_08-01-20
TRPP_EXTRACT_2020_11_15_08-01-20
TRPP_EXTRACT_2020_11_14_08-01-10
TRPP_EXTRACT_2020_11_13_08-01-30
TRPP_EXTRACT_2020_11_12_08-01-40
TRPP_EXTRACT_2020_11_12_08-01-50
TRPP_EXTRACT_2020_11_10_08-01-10
TRPP_EXTRACT_2020_11_09_08-01-20
I would like to compare last week Monday sales data (TRPP_EXTRACT_2020_11_09_08-01-20) and this week Monday sales data (TRPP_EXTRACT_2020_11_16_08-01-20). Next week date will be automatically analysis from (TRPP_EXTRACT_2020_11_16_08-01-20) to (TRPP_EXTRACT_2020_11_23_08-01-20)
Example of Result.
COMPARE WEEKS.PNG
Files; - Monday's data.(Last two weeks only)
TRPP_EXTRACT_2020_11_16_08-01-20.xlsx (with duplicate line item)
TRPP_EXTRACT_2020_11_09_08-00-18.xlsx ((without duplicate line item)
Our daily sales data stored in Excel under the "sales" folder. I am trying to compare "Monday Last week's Sales" with "Monday this week's Sales" based on the date.
I would like to create a new table to achieve my result - What are the item are newly added (unique) from Monday last week sales compare to Monday this week's Sales. I don’t want to change the file reference manually every week. How can I automate these process in Power BI. Can you please advise the best alternative way?
The file name is standard TRPP_EXTRACT, only the date and time will be changed on daily basis. The data contain two headers are item and sales area. The item and sales area can be unique some of the files and some of the files are duplicated/repeated.
Sales Data stored in Excel like this under the Sales folder. (Note: The date not stored in my data (inside the Excel). Date showing only my Excel file).
TRPP_EXTRACT_2020_11_16_08-01-20
TRPP_EXTRACT_2020_11_15_08-01-20
TRPP_EXTRACT_2020_11_14_08-01-10
TRPP_EXTRACT_2020_11_13_08-01-30
TRPP_EXTRACT_2020_11_12_08-01-40
TRPP_EXTRACT_2020_11_12_08-01-50
TRPP_EXTRACT_2020_11_10_08-01-10
TRPP_EXTRACT_2020_11_09_08-01-20
I would like to compare last week Monday sales data (TRPP_EXTRACT_2020_11_09_08-01-20) and this week Monday sales data (TRPP_EXTRACT_2020_11_16_08-01-20). Next week date will be automatically analysis from (TRPP_EXTRACT_2020_11_16_08-01-20) to (TRPP_EXTRACT_2020_11_23_08-01-20)
Example of Result.
COMPARE WEEKS.PNG
Files; - Monday's data.(Last two weeks only)
TRPP_EXTRACT_2020_11_16_08-01-20.xlsx (with duplicate line item)
TRPP_EXTRACT_2020_11_09_08-00-18.xlsx ((without duplicate line item)
