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.
Thanks
Solved! Go to Solution.
Add 'RETURN StartDate' on the end.
Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
The alternative to this would be...
Replace 'VAR StartDate = ' with 'RETURN'
I prefer the VAR option for readability though.
Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
Add 'RETURN StartDate' on the end.
Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
KNP,
Feels like DAX is a mix of most progamming tool. Similiar to return in
R-studio/Python. Thanks much. This helped lots.
The alternative to this would be...
Replace 'VAR StartDate = ' with 'RETURN'
I prefer the VAR option for readability though.
Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
Ahh Got it. Totally agree with you on that. Thanks Again.
@Flichaster Try:
NewtoDax =
VAR NEW_OverallStartDate = [NEW_OverallStartDate]
VAR StartDate =
CALCULATE(
MIN('Everything Clarity, Project without totals'[Start Date]),
REMOVEFILTERS('Everything Clarity, Project without totals'[Start Date])
)
@Greg_Deckler
I still get the same error.
My start date follows a Date Hierarchy, My initial Picture with removefilters('StartDate') is a new table that does not follow Date Hierarchy
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.