Get Budget Level based on latest Data

[joshua1990]

I have a simple table like this:

Article	Budget	Date
A	50	01.01.2021
A	50	01.03.2021
B	40	01.01.2021
B	60	01.03.2021

As you can see the table lists the budget level per Article.

Now I have a bar chart that shows me the Actuals vs Budget for the last 14 days. Somehow I need to project the latest level until the newest level. But how? The bar chart is filtered for the last 14 days.

[amitchandak]

@joshua1990 , You can use date slicer or related date slicer for last 14 days.

You can try a measure like this for latest budget

Measure =
VAR __id = MAX ('Table'[Article] )
VAR __date = CALCULATE ( MAX('Table'[Last Date ] ), ALLSELECTED ('Table' ), 'Table'[Article] = __id )
CALCULATE ( sum ('Table'[Budget] ), VALUES ('Table'[Article] ),'Table'[Article] = __id,'Table'[Last Date ] = __date )