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!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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])