wrong measure in calculation group

[pedroccamaraDBI]

Hi guys,
I have 4 main measures, cost, net, profit and gross. I've done a calculation group with tabular editor to calculate several ti measures like LM, LQ and LY.
My LY measure is not working, for any of the measures selected.
This is my calculated item :

 CALCULATE( SELECTEDMEASURE(), DATEADD( 'Tab Dates'[Date], -1, YEAR ))

Pretty simple and it's not working. My first time in calculation groups. This is my visual:

Can anyone help me?
Thanks a lot
Pedro

[v-xulin-mstf · Accepted solution]

Hi @pedroccamaraDBI

Please try measure as:

CALCULATE( SELECTEDMEASURE(),PREVIOUSYEAR( 'Tab Dates'[Date])

 If you still have the problem, please share your sample pbix file, that will be a great help.

Best Regards,
Link

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@pedroccamaraDBI , is Tab Dates is calendar table marked as date table?

also, Year/Q/M is coming from Tab Dates?

refer Why Time Intelligence Fails - Power bi 5 Savior Steps for TI: https://youtu.be/OBf0rjpp5Hw

[pedroccamaraDBI]

yes @amitchandak for both questions