Week to Week Comparison

[Lsvzz]

Hi!

Im trying to create a comparison between last 2-3 weeks of sales that can be filtered per salesperson. I managed to create a table with the information of just last week, but i would like to get the table or the matrix to update automatically so i dont have to update it manually every meeting. And if possible using a color green/red to mark whenever its going up or down in sells per week vs last week.

My guess is that it would be something using today() - x. Im just very new and i dont know the full structure.

It would be something like this:

	week x	week y	week z
Account1	$	$	$
Account2	$	$	$
Account3	$	$	$

 Thanks in advance!

[v-sihou-msft · Accepted solution]

@Lsvzz

In this scenario, I think you can add a flag column to tag Current Week and Last Week.

IsWithin2Weeks =
IF (
    YEAR ( Table[Date] ) = YEAR ( TODAY () )
        && WEEKNUM ( Table[Date], 2 ) >= WEEKNUM ( TODAY (), 2 )-1,
    1,
    0
)

Then put this column into Visual Level, make it "is 1".

Regards,