calculate total orders same selected week last month

[lawada]

hello,

i need to create a measure to calculate total orders in the same selected week last month 

for example if i selected from the date slicer period ( jan13->jan19) i want the measure to calculate the total orders

for the period (Dec16->Dec22) which is in the last month

[themistoklis]

Hello @lawada 

Try this formula in a measure not column:

Measure = 
SUMX(
    DATEADD(Table[Date],-28,DAY),
    [Amount]
)