Forum Discussion

renlaforest's avatar
renlaforest
Helper I
4 years ago
Solved

Cumulative Daily Target

Hi - It's embarassing how many hours I've spent trying to figure this out.   My Data Model has a table called Project Setup with project in each row. Each project has a column called Start Date, Cl...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi renlaforest 
    Here is the sample file with the solution https://we.tl/t-pHo4kYyRle

    ENTargetToDate = 
VAR CrrentDate = MAX ( EnumDates[Date] )
VAR FirstDateInFilter = CALCULATE ( MIN ( EnumDates[Date] ), ALLSELECTED () )
VAR NumberOfDays = DATEDIFF ( FirstDateInFilter, CrrentDate, DAY ) + 1
VAR ProjectTarget = SELECTEDVALUE ( 'ProjectSetup'[DailyENTarget] )
RETURN
    ProjectTarget * NumberOfDays

tamerj1's avatar
tamerj1
Community Champion
4 years ago

renlaforest 

I guess I missed something 

ENTargetToDate =
VAR CrrentDate =
    MAX ( EnumDates[Date] )
RETURN
    CALCULATE (
        SUM ( 'ProjectSetup'[DailyENTarget] ),
        ALLEXCEPT ( 'ProjectSetup', 'ProjectSetup'[ProjectName] ),
        REMOVEFILTERS ( EnumDates ),
        FILTER ( EnumDates, EnumDates[Date] >= CrrentDate )
    )
renlaforest's avatar
renlaforest
Helper I
4 years ago

Thank you tamerj1 ,

 

Unfortunately, I still get the same result.

 

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    Can you please share a sample file?

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    renlaforest 
    Please try this just to see what results you get

    ENTargetToDate =
VAR CrrentDate =
    MAX ( EnumDates[Date] )
RETURN
    CALCULATE (
        SUM ( 'ProjectSetup'[DailyENTarget] ),
        REMOVEFILTERS (),
        EnumDates[Date] <= CrrentDate
    )
    • renlaforest's avatar
      renlaforest
      Helper I
      4 years ago

      Hi tamerj1 ,

      It's now showing the total for 6 days (6*235) - although there are 7 days listed:

       

      • tamerj1's avatar
        tamerj1
        Community Champion
        4 years ago

        renlaforest 
        Ok Then try

        ENTargetToDate =
VAR CrrentDate =
    MAX ( EnumDates[Date] )
RETURN
    CALCULATE (
        SUM ( 'ProjectSetup'[DailyENTarget] ),
        REMOVEFILTERS (),
        VALUES ( EnumDates[Date] )
        EnumDates[Date] <= CrrentDate
    )