Forum Discussion

Lstatsea23's avatar
Lstatsea23
Frequent Visitor
3 years ago

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_Daniel's avatar
    wdx223_Daniel
    Community Champion

    ADC Daily Targets:=

    TOTALMTD(sum( 'FactADCMonthlyTargets'[ADCTarget]),'DimDate'[DateKey])