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!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
is there a way of passing or grabbing the first date in a date slicer to a calculation?
i want to calculated a target based on whether i am looking at this years data or last year data. Just wondering if there is a dynamic way to do this?
Proud to be a Super User!
Solved! Go to Solution.
should be able to use something like
MIN( ALLSELECTED ( DateTable[Date] )
or
FIRSTDATE( ALLSELECTED (DateTable[Date]) )
should be able to use something like
MIN( ALLSELECTED ( DateTable[Date] )
or
FIRSTDATE( ALLSELECTED (DateTable[Date]) )
thank you!
Proud to be a Super User!
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.