Forum Discussion
joshua1990
Post Prodigy
Post ProdigyGet Budget Level based on latest Data
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.
1 Reply
- amitchandak
Super User
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 )
