Weekly comparison

[nadeemrajabali]

Hi All,

I have an excel file where Sales manager records their expected sales from the remaining month.

It gives an idea of weekly change. Currently I am copyin and pasting it every week in seperate file to track weekly change. Is there a way I can import my file every week in Power BI where a week number or date of the specific day of week is created automatically with my data? this will help me track the change weekly.

[v-danhe-msft]

Hi @nadeemrajabali ,

Could you please post some simple sample data and your desired result to have a test if possible?

You could see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Regards,

Daniel He

[nadeemrajabali]

Hi Daniel,

Did you get a chance to have a look?

Nads

[nadeemrajabali]

Thanks for reaching out Daniel.

Below is what will be inptu by manager every friday of the week in estimate column.

Then I take these figures and transfer it to output file on relvant week.

Can I import data in power BI every week where it creates new entry by Week dates as per my output file?

Sorry If I have confused you.

Input
Account	Target for the Month	Estimate	Var
ABC	900000	856900	-43100
XYZ	123444	113415	-10029
PQR	14698	16520	1822
TUX	56478	70000	13522
IQL	18563	15000	-3563
Output
		Weekly Estimate
Account	Target for the Month	3/05/2019	10/05/2019	17/05/2019	24/05/2019	31/05/2019	Var
ABC	900000	900000	920000	850000	856900		-43100
XYZ	123444	123444	125000	115000	113415		-10029
PQR	14698	14698	18000	17000	16520		1822
TUX	56478	56478	57000	60000	70000		13522
IQL	18563	18563	19000	18000	15000		-3563