Calculation up to today

[Tomek1982]

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 calculated only to the current year and not for the whole year.

How to do that?

pbix is here

[Wilson_ · Accepted solution]

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