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.
I currently have only the 1st day value for every month but I need to repeat the same value for every day of the month. I have tried the below but it does not work. I appreciate any help you can offer.
ADC Daily Targets:=
var Days = distinct('DimDate'[DateKey])
var DailyTargets =
calculate(
sum( 'FactADCMonthlyTargets'[ADCTarget]),
Days,
REMOVEFILTERS( 'DimDate')
)
return
DailyTargets
ADC Daily Targets:=
TOTALMTD(sum( 'FactADCMonthlyTargets'[ADCTarget]),'DimDate'[DateKey])
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.