DATEADD measure for # of intervals

[tomislav]

HI, 

I have report level calendar filter, and I'm using DISTINCTCOUNT(Calendar[Date]) to see how many days is selected.

NumberOfSelectedDays := DISTINCTCOUNT(Calendar[Date])

CAshIn_Previous_Period := CALCUATE( [CashIn]; DATEDD(Calendar[Date]; -[NumberOfSelectedDays]; DAYS)

And I do not get wanted shift in days, I get just shift of one day. Please advise. Thanks

[itsmebvk]

@tomislav  Try to use following method

Count = DATEDIFF(
					MIN(Sheet1[Date]),
					MAX(Sheet1[Date]),
					DAY
					)

Calc Discount = CALCULATE([Sum Discount],DATEADD(Sheet1[Date],-[Count],DAY))

See the attached  PBIX, correct me if I misunderstood your requirement.