Forum Discussion

Tomek1982's avatar
Tomek1982
Helper I
3 years ago
Solved

Calculation up to today

Hi, I am trying to create a graph for KPI to see where I am versus scoring with a following result. What I would like to achieve is to limit this purple line with current status so it is calc...
Need Help
  • Wilson_'s avatar
    Wilson_
    3 years ago

    Hi Tomek,

     

    I've added an IF function to your running twelve month points measure, to first check if the date is not in the future. Please let me know if this works for you or if you were looking for something different. 😄

     

    points R12m = 
IF ( 
    MIN ( 'calendar'[Date] ) <= TODAY(),
    CALCULATE (
        [points],
        DATESINPERIOD ( 'calendar'[Date], MAX ( 'calendar'[Date] ), -12, MONTH )
    )    
)

     

    ----------------------------------
    If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)

Wilson_'s avatar
Wilson_
Memorable Member
3 years ago

Hi Tomek,

 

I've added an IF function to your running twelve month points measure, to first check if the date is not in the future. Please let me know if this works for you or if you were looking for something different. 😄

 

points R12m = 
IF ( 
    MIN ( 'calendar'[Date] ) <= TODAY(),
    CALCULATE (
        [points],
        DATESINPERIOD ( 'calendar'[Date], MAX ( 'calendar'[Date] ), -12, MONTH )
    )    
)

 

----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)