Forum Discussion
pedroccamaraDBI
Post Partisan
5 years agowrong measure in calculation group
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, fo...
- 5 years ago
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,
LinkIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
amitchandak
Super User
5 years agopedroccamaraDBI , 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
- pedroccamaraDBI5 years ago
Post Partisan
yes amitchandak for both questions