Current 7 days vs previous 7 days comparison.

[Arvind_123]

Hi Team,

I need current 7 days Vs previous 7 days comparsion data .

need data as shown in image.

Thanks,

Arvind

[Fowmy · Accepted solution]

@Arvind_123 

Use these two measures:

Sales Last 7 Days = 
Var __Last7Days = DATESINPERIOD( 'Date'[Date] , MAX('Date'[Date]) , -7 , DAY )
Var __Result = CALCULATE( [Sales Amount] , __Last7Days)
RETURN
    __Result

Sales Previous 7 Days = 
Var __Last7Days = DATESINPERIOD( 'Date'[Date] , MAX('Date'[Date]) - 7 , -7 , DAY )
Var __Result = CALCULATE( [Sales Amount] , __Last7Days)
RETURN
   __Result