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!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register 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])
User | Count |
---|---|
11 | |
9 | |
6 | |
5 | |
4 |