Get data series from lastweek, lastmonth reading date point

[anhngv]

I have a data set which everyday (rundate) I collect bookings (bkd) of future flights (flt_date). AP is number of days flight date pior to rundate (AP = Flt_date - Rundate). A data sample is attached as below:

I would like to compare booking data today (or whatever day I filter) with what is collected in a week ago (-7 days from today) or a month ago by AP.

I can compare with last day (of whatever rundate I filter) by previosday syntax

Manythanks

[amitchandak · Accepted solution]

@anhngv , with help from date table example

Weekbehind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-7,DAY))

Month behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Month))
Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Year))

[anhngv]

solved, thanks and sorry I'm newbie 😄