Same Period Last Week

[finzilla]

Hello... I'll simplify this by having only five columns within the SalesTransaction table:

TransDate (eg. 05/29/2018)

TransTimePeriod (eg. 06:30-07:00)

SaleAmount (eg. 200.00)

ThisWeek ( measure where = 1 when True)

LastWeek (measure where= 1 when True)

I also have a Date table.

I want to create a visual that shows the following:

Essentially I need to summarize the SaleAmount for each TransTimePeriod (easy so far), and then compare it for the same period last week (which is where I'm getting stuck).

[nfero68]

Working solution! THX! 

[ChandeepChhabra]

@finzilla Please share your sales transaction table

[finzilla]

Here is a simplified example of the SalesTransaction table (it's a whole lot more sophisticated but this will do):

Date file is just a list of dates.

[v-jiascu-msft]

Hi @finzilla,

Please check the demo in the attachment. 

1. I would suggest adding a column in the date table.

WeekNum = WEEKNUM([Date],2)

2. Create three measures.

Today =
CALCULATE ( SUM ( Table1[SaleAmount] ), 'Calendar'[Date] = TODAY () )

LastWeek =
CALCULATE (
    SUM ( Table1[SaleAmount] ),
    'Calendar'[WeekNum]
        = WEEKNUM ( TODAY (), 2 ) - 1
)

Variance = [Today] - [LastWeek]

Best Regards,

Dale