Forum Discussion
Running Total - DAX
FawadRehman This should work... Let me know.
Running Total COLUMN = CALCULATE ( SUM ( TabelForecast[Forecast] ), ALLEXCEPT ( TabelForecast, TabelForecast[M#] ), TabelForecast[MonthYear] <= EARLIER ( TabelForecast[MonthYear] ) )
Sean Thank you, this is great. But at the same time, i have this in table,then i make a outer left join this table to another table to insert my running my Running total column values. I am very new in Power BI so please excuse my stupid logic or questions. Thanks
Can you provide a sample of the desired final result? Are you doing a summary table?
Project Name M# MonthYear Forecast RunningTotal KR 0779930-AA December, 2015 $ 600,000.00 $ 600,000.00 KR 0779930-AA January, 2016 $ 865,000.00 $ 1,465,000.00 KR 0779930-AA March, 2016 $ 1,500,000.00 $ 2,965,000.00 KR 0779930-AA August, 2016 $ 500,000.00 $ 4,065,000.00 KR 10779930-AA July, 2016 $ 600,000.00 $ 3,565,000.00 KR 107799DD February, 2016 $ 1,100,000.00 $ 1,100,000.00 KR 107799DD April, 2016 $ 10,000.00 $ 1,110,000.00 KR 107799DD May, 2016 $ 2,500,000.00 $ 3,610,000.00 MP DO6000 December, 2015 $ 1,000,000.00 $ 1,000,000.00 MP DO6000 January, 2016 $ 3,000,000.00 $ 4,000,000.00 MP DO6000 February, 2016 $ 3,100,000.00 $ 7,100,000.00 JR R16ID80004 December, 2015 $ 2,300,000.00 $ 2,300,000.00 JR R16ID80004 January, 2016 $ 2,500,000.00 $ 4,800,000.00 JR R16ID80004 February, 2016 $ 3,300,000.00 $ 8,100,000.00 JR R16ID80004 March, 2016 $ 4,000,000.00 $ 12,100,000.00 MP RAM15IE10101 October, 2015 $ 500,000.00 $ 500,000.00 Here is the table. No its to summary table, just normal table and i am add one new calculated column "Running table". Btw, projects could go 5 years or more so Max date funtion is necessary.
FawadRehman Why don't you want to do the Running Total in the new Merged Table?
Sean other table is coming from other source which has almost same columns and i want to join with M# ,MonthYear & Project Name.