Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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.
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.
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
103 | |
76 | |
66 | |
63 |
User | Count |
---|---|
142 | |
105 | |
102 | |
81 | |
68 |