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 ) ) )
Running Totals Added Together to produce a forcast
Hi, Im trying to add together 2 RT Totals but cant seem to figure it out 😞 I have a running total in one table for the Actuals (P6_PowerBI_Actual_Labor_Units) Calculation: P6_RT_Actual_Labor_Units = CALCULATE(SUM(P6_PowerBI_Actual_Labor_Units[Value]),FILTER(ALLSELECTED(PowerBI_Date[Date]),PowerBI_Date[Date]<=MAX(P6_PowerBI_Actual_Labor_Units[Date]))) And another table for the remaining hours (P6_PowerBI_Remaining_Labor) Calculation: P6_RT_Remaining_Labor = CALCULATE(SUM(P6_PowerBI_Remaining_Labor[Value]),FILTER(ALLSELECTED(PowerBI_Date[Date]),PowerBI_Date[Date]<=MAX(P6_PowerBI_Remaining_Labor[Date]))) Both tables are joined together with a Date table PowerBI_Date. Current results if i sum both together. Intended Result. Any help would be appricated, Thanks in Advance.
Running Total
Hi I have a table named 'Kartela' with posting date and amount i need to build a measure according to other solutions in the comunity but it does not completely work . When I keep the table simple it works but when i add more info like the remarks of the movement is not working any idea how to fix it ? thea measure is Running Total = Calculate ( SUM(kartela[blc]), FILTER( ALL('kartela'[Posting Date] ),'kartela'[Posting Date] <= MAX('kartela'[Posting Date])))
Acummulated tickets along time - Show acummulated after today - Cumulative Totals
Hi guys, I need your help... I'm trying to show the accumulated open tickets along the months, but on visuals they extend until december. I would like to see until the current month, I have try almost everything, but not worked, even the ChatGPT could give me a good answer. You are my last hope. I use this measure: CALCULATE ( CALCULATE ( COUNTROWS ( f_Suporte ), FILTER ( ALL ( f_Suporte[##Related Status_Cliente] ), f_Suporte[##Related Status_Cliente] = "Ativo" ), FILTER ( ALL ( f_Suporte[##StatusTicket] ), f_Suporte[##StatusTicket] = "ABERTO" ) ), FILTER ( ALL ( Date_Table_TR[Date] ), Date_Table_TR[Date] <= MAX ( Date_Table_TR[Date] ) ) )Running Total
Hi I have a table named 'Kartela' with posting date and amount i need to build a measure according to other solutions in the comunity but it does not completely work . When I keep the table simple it works but when i add more info like the remarks of the movement is not working any idea how to fix it ? thea measure is Running Total = Calculate ( SUM(kartela[blc]), FILTER( ALL('kartela'[Posting Date] ),'kartela'[Posting Date] <= MAX('kartela'[Posting Date])))
Running total using datediff in a measure
I need a dynamic measure that can make a running total summing the amount of days between two dates per employee. I want the measure to be able to run in 12 months 'windows'. Please regard I am not able to use window functions since i use analysis services which doesn't include window functions. This is the data: Among other attempts I have tried: Running total = CALCULATE( sumx( SUMMARIZE('Data', "result", DATEDIFF(MAX('Data'[Date incurred]), MIN('Data'[Date paid]), DAY )) , [result]) , DATESINPERIOD('Data'[Date paid], MAX('Data'[Date paid]), -1, YEAR)) Anybody know of a solution where one can make running totals like that without using window functions?
