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.
Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
never-displayed
View discussion in a popup
we can average all weeks which have number.
calculate(average([COGS per day]),[COGS per day]>0)
we also can average all numbers before today.
calculate(average([COGS per day]),[week]<today())
View solution in original post
