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
I am trying to create a measure that only calculates the sum before a specific date using the averageX function, could anyone advise me how I would specify this in the KEEPFILTERS part of the expression? I have been trying to simply put "<Date(2015,10,06)" after the (Master[Date]) and a few other things but nothing is working currently
This is the function I currently have
Solved! Go to Solution.
@Beefcake , Try
VAR VALUEZ = AVERAGEX(
Filter(values(Master[Date]), Master[Date] <Date(2015,10,06)),
CALCULATE(SUM('Master'[Order_Demand]))
)
That worked, thanks very much. Not sure why I insisted on continuing with KEEPFILTERS
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.