topic Get Budget Level based on latest Data in DAX Commands and Tips

Get Budget Level based on latest Data

joshua1990 — Sun, 04 Jul 2021 15:56:05 GMT

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.

Re: Get Budget Level based on latest Data

amitchandak — Mon, 05 Jul 2021 06:29:06 GMT

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 )