Week vs Week sales

[Lsvzz]

Hi!

I been trying to create a small table that shows a comparison between the last 3-4 weeks of sales between different accounts, and if possible add something like colors to show which ones went down/up. 

My guess is that it would be something like Today() - x days, im just not there yet to create it myself. Is there any formula that i could use that does this already?

heres an example:

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

Any help would be apreciated. 

[v-jiascu-msft · Accepted solution]

Hi @Lsvzz,

Can you share a sample in TEXT mode please? The .pbix file would be great. 

In this scenario, we need a date table. 

Calendar =
ADDCOLUMNS (
    CALENDAR ( DATE ( 2017, 1, 1 ), DATE ( 2017, 12, 31 ) ),
    "Weeknum", WEEKNUM ( [Date], 2 )
)

The relationship will be established through date. This week could be [Weeknum] = weeknum(today()). Last 1 week could be [weekNum] = weeknum(today()) -1. Etc. 

Best Regards!

Dale