Week Over Week Calculations

Hi Vvelarde,

I have already figured it myself.

I working with my custom calendar table.

The function is (for absolute diff):

Clicks WoW Abs =
(
SUMX(FILTER('AdWords KW Data L2W', RELATED('Calendar'[Last X Weeks])="Last Week-00"),'AdWords KW Data L2W'[Clicks])
-
SUMX(FILTER('AdWords KW Data L2W', RELATED('Calendar'[Last X Weeks])="Last Week-01"),'AdWords KW Data L2W'[Clicks])
)

Calendar is here (free to use): 
https://docs.google.com/spreadsheets/d/1-55vUYZrYKduI8tbuK5nk9GXBUc7X7uNMcS1mXRIdoI/export?format=csv&id=1-55vUYZrYKduI8tbuK5nk9GXBUc7X7uNMcS1mXRIdoI&gid=0

Just import it to PBI as "From Web". 

Figured it out myself long time ago.

I am using custom calendar table. For absolute diff, this is the formula:

Clicks WoW Abs = (
SUMX(FILTER('AdWords KW Data L2W', RELATED('Calendar'[Last X Weeks])="Last Week-00"),'AdWords KW Data L2W'[Clicks])
-
SUMX(FILTER('AdWords KW Data L2W', RELATED('Calendar'[Last X Weeks])="Last Week-01"),'AdWords KW Data L2W'[Clicks])
)

The calendar is here:

https://docs.google.com/spreadsheets/d/1-55vUYZrYKduI8tbuK5nk9GXBUc7X7uNMcS1mXRIdoI/edit?usp=sharing

Import link for PBI (free to use):
https://docs.google.com/spreadsheets/d/1-55vUYZrYKduI8tbuK5nk9GXBUc7X7uNMcS1mXRIdoI/export?format=csv&id=1-55vUYZrYKduI8tbuK5nk9GXBUc7X7uNMcS1mXRIdoI&gid=0

DZ

Vvelarde,

thank you! Another option I figured it myself long time ago. Abs diff:

Clicks WoW Abs =

(
SUMX(FILTER('AdWords KW Data L2W', RELATED('Calendar'[Last X Weeks])="Last Week-00"),'AdWords KW Data L2W'[Clicks])
-
SUMX(FILTER('AdWords KW Data L2W', RELATED('Calendar'[Last X Weeks])="Last Week-01"),'AdWords KW Data L2W'[Clicks])
)

I have custom calendar:

https://docs.google.com/spreadsheets/d/1-55vUYZrYKduI8tbuK5nk9GXBUc7X7uNMcS1mXRIdoI/edit#gid=0

Link for PBI (free to use):

https://docs.google.com/spreadsheets/d/1-55vUYZrYKduI8tbuK5nk9GXBUc7X7uNMcS1mXRIdoI/export?format=csv&id=1-55vUYZrYKduI8tbuK5nk9GXBUc7X7uNMcS1mXRIdoI&gid=0

DZ

Vvelarde,

thank you! Another option I figured it myself long time ago. Abs diff:

Clicks WoW Abs =

(
SUMX(FILTER('AdWords KW Data L2W', RELATED('Calendar'[Last X Weeks])="Last Week-00"),'AdWords KW Data L2W'[Clicks])
-
SUMX(FILTER('AdWords KW Data L2W', RELATED('Calendar'[Last X Weeks])="Last Week-01"),'AdWords KW Data L2W'[Clicks])
)

I have custom calendar:

https://docs.google.com/spreadsheets/d/1-55vUYZrYKduI8tbuK5nk9GXBUc7X7uNMcS1mXRIdoI/edit#gid=0

Link for PBI (free to use):

https://docs.google.com/spreadsheets/d/1-55vUYZrYKduI8tbuK5nk9GXBUc7X7uNMcS1mXRIdoI/export?format=csv&id=1-55vUYZrYKduI8tbuK5nk9GXBUc7X7uNMcS1mXRIdoI&gid=0

DZ

This is almost  perfect for me.  Made a couple small changes due to the way PBI counts days - otherwise this is awesome!

WoW =
VAR Week1 =
    CALCULATE (
        SUM ( Table1[Sales] ),
        DATESINPERIOD ( Table1[Today], SELECTEDVALUE ( Table1[Today] ) - 0; -7, DAY )
    )
VAR Week2 =
    CALCULATE (
        SUM ( Table1[Sales] ),
        DATESINPERIOD ( Table1[Today], SELECTEDVALUE ( Table1[Today] ) - 7; -7, DAY )
    )
RETURN
    DIVIDE ( Week1, Week2 ) - 1

@Vvelarde