Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!