Running Total - Stop at a specific date
Hello. New to Power BI. I did a quick measure to create the running total for the "actual" data and it's show all months. How do I update the DAX below to stop at September but then update it to October and continue as real data is added? Thank you! Sum of Sub System Amount running total in Fiscal Month = CALCULATE( SUM('Combined'[Sub System Amount]), FILTER( CALCULATETABLE( SUMMARIZE( 'Fiscal Period Description', 'Fiscal Period Description'[Period], 'Fiscal Period Description'[Fiscal Month] ), ALLSELECTED('Fiscal Period Description') ), ISONORAFTER( 'Fiscal Period Description'[Period], MAX('Fiscal Period Description'[Period]), DESC, 'Fiscal Period Description'[Fiscal Month], MAX('Fiscal Period Description'[Fiscal Month]), DESC ) ) )
