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

Hi renlaforest 

you may try

 

ENTargetToDate =
VAR CrrentDate =
    MAX ( EnumDates[Date] )
RETURN
    CALCULATE (
        SUM ( 'ProjectSetup'[DailyENTarget] ),
        ALLEXCEPT ( 'ProjectSetup', 'ProjectSetup'[ProjectName] ),
        FILTER ( EnumDates, EnumDates[Date] >= CrrentDate )
    )

 

renlaforest's avatar
renlaforest
Helper I
4 years ago

Hi tamerj1 ,

 

Thank you - I'm still ending up with the same result. I really appreciate your help:

 

  • 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?