Question about Measure "till today"

[Anonymous]

Hello Power BI Community 🙂

A beginner question to the experts, How can I limit the time period in my measure so that only the period "until today" is displayed?

Sum of Concession YTD =
TOTALYTD(SUM('Target_Total_DIM'[Concession]), 'Calendar_DIM'[Date])

Thanks for your help

[Ahmedx · Accepted solution]

pls try tgis

Maesure=
VAR _today = TODAY()
RETURN
calculate( SUM('Target_Total_DIM'[Concession]), filter( all('Calendar_DIM') , 'Calendar_DIM'[Date] <= _today ))

[Anonymous]

Thanks, that works 🙂

[Anonymous]

Hi 🙂

Thanks for help. With the formula I get the same value out. I have values in the table that are in the future, and I want the measure to show only the values up to today.

[amitchandak]

@Anonymous , in case you need life to date

calculate( SUM('Target_Total_DIM'[Concession]), filter( all('Calendar_DIM') , 'Calendar_DIM'[Date] <= max('Calendar_DIM'[Date]) ))