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

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

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
    )
      • renlaforest's avatar
        renlaforest
        Helper I
        4 years ago

        Hitamerj1 - there's an issue with the last EnumDates[Date]