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.
Hello every one,
I want to make a ytd and p-ytd report, via a selection from a slicer the user would see the offers in the selected year and the offers in the selected year -1.
I wrote the measure bellow but doesnot work.
Solved! Go to Solution.
Hi @Anonymous
Seems you forgot to put the "- 1" after "x".
Also you cannot calculate a variable inside CALCULATE
Offers_selYear =
VAR x =
SELECTEDVALUE ( 'Query1'[year] )
RETURN
CALCULATE (
DISTINCTCOUNT ( Query1[offerid] ),
Query1[Type] = "Offers",
Query1[year] = x - 1
)
Hi @Anonymous
Seems you forgot to put the "- 1" after "x".
Also you cannot calculate a variable inside CALCULATE
Offers_selYear =
VAR x =
SELECTEDVALUE ( 'Query1'[year] )
RETURN
CALCULATE (
DISTINCTCOUNT ( Query1[offerid] ),
Query1[Type] = "Offers",
Query1[year] = x - 1
)