topic Previous Period Sales Measure output is the same as Current Period Sales in DAX Commands and Tips

Previous Period Sales Measure output is the same as Current Period Sales

Anonymous — Wed, 22 Jun 2022 02:11:54 GMT

Hello everyone, I'm trying to build out a Sales Previous Period measure, but for some reason the output is the same number as the sales for the current period, do you noticed anything wrong with this?

Sales Last Period =

VAR Sales = SUM(‘Table’[Sales])

VAR PeriodEnd = FIRSTDATE(‘Table’[Date]) -1

VAR PeriodStart =

PeriodEnd -

DATEDIFF(

FIRSTDATE(‘Table’[Date]),

LASTDATE(‘Table’[Date]),

DAY

)

VAR Result =

CALCULATE(

Sales,

DATESBETWEEN(

‘Table’[Date],

PeriodStart,PeriodEnd

)

RETURN

Result

Thanks!

Re: Previous Period Sales Measure output is the same as Current Period Sales

Jihwan_Kim — Wed, 22 Jun 2022 03:05:49 GMT

Hi,

I am not sure how your data model looks like, but please try the below.

Sales Last Period = VAR PeriodEnd = FIRSTDATE ( 'Table'[Date] ) - 1 VAR PeriodStart = PeriodEnd - DATEDIFF ( FIRSTDATE ( 'Table'[Date] ), LASTDATE ( 'Table'[Date] ), DAY ) VAR Result = CALCULATE ( SUM ( 'Table'[Sales] ), DATESBETWEEN ( 'Table'[Date], PeriodStart, PeriodEnd ) ) RETURN Result

Re: Previous Period Sales Measure output is the same as Current Period Sales

Anonymous — Wed, 22 Jun 2022 13:53:08 GMT

Thank you!