Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi all,
Hope somebody can help me.
I have simple table (viz print screen) contains Quarters, Number, % from previous period.
BUT I want to use Quarter filter and compare for example 2021-Q1 and 2022-Q1, this is problem, because it doesnt work anymore, viz printscreen.
As you can see, it is still calculating previous period and it is not able to be dynamic.
This is my formula:
Solved! Go to Solution.
Hi @lucie_rabochova ,
Please use OFFSET and ALLSELECTED in dax to calculate previous row value, please see below and attched PBI file
Thank you so much! This is amazing solution and it works perfect.
All the best, Lucie