Help with Calculate Formula (adding -1 to filter is not working)

[tmendoza]

Hello DAXers,

Can anyone tell me why this works:

CALCULATE(SUMX(GL,GL[Actual Amount]),GL[Category] IN {"HC","FTE"}, GL[SnapShot] = GL[SnapShot] )

But this doesn't:

CALCULATE(SUMX(GL,GL[Actual Amount]),GL[Category] IN {"HC","FTE"}, GL[SnapShot] = GL[SnapShot]-1 )

And can anyone offer me a solution that will make this DAX formula work?

SnapShot is a column of Data type: Decimal Number and Format: Whole Number.

I've tried using the INT command and the latter of the two formulas still doesn't work. It just draws a blank.

Thanks!!!

[Nathaniel_C]

Hi @tmendoza ,

What are you trying to do with this?

GL[SnapShot] = GL[SnapShot]-1 )

[tmendoza]

Hello there,

SnapShot is a value that expresses a period. ex. 202001, 202002, 202003, 202004 etc.

I want my measure to give me the amount for the prior period being looked at. 

So if my slicer was to show 202003, then my measure would give me the amount for 202002. Thus, the [SnapShot]-1 Jazz.