measure help

[Craigc3814]

I am trying to create a measure that calculates running total by year. I have the below measure but it is calculating since the beginning of time. I know its a simple fix but I cannot get it

Running Total MEASURE =
CALCULATE (
SUM ( 'MSD_ALLOC_RECON_ACT (2)'[Spent] ),
FILTER (
ALL ( 'MSD_ALLOC_RECON_ACT (2)' ),
'MSD_ALLOC_RECON_ACT (2)'[ACCOUNTING_Month]<= MAX ( 'MSD_ALLOC_RECON_ACT (2)'[ACCOUNTING_Month] )
)
)

 

[Matt Allington]

Never attempt time intelligence functions without a calendar table. Get a calendar table and it will work.

Create calendar Tables in Power BI

Learn how to create a Power BI calendar table using the basic rules and approach to setting it up daily, weekly or monthly.

exceleratorbi.com.au

DAX Time Intelligence Explained

Level: Beginners I help a lot of people on forums who ask questions about time intelligence for DAX. If you are just starting out then the chances are that you may not even be clear what time intelligence is and hence sometimes you don’t even know what to ask. Often [...]Read More »

exceleratorbi.com.au

make sure you use the calendar date column in the measure and also your visual