Forum Discussion
Lstatsea23
3 years agoFrequent Visitor
Extend Days in Month
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
1 Reply
- wdx223_DanielCommunity Champion
ADC Daily Targets:=
TOTALMTD(sum( 'FactADCMonthlyTargets'[ADCTarget]),'DimDate'[DateKey])