Forum Discussion

joshua1990's avatar
joshua1990
Icon for Post Prodigy rankPost Prodigy
5 years ago

Get 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 p...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

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 )