Forum Discussion
Dates Running Total/ % Running total
Hi Need Help! I want to make a running total of dates. also % runinng total verson too. could anyone tell me what dax i need to use? thanks
Anonymous Rather assuming your requirement and data, could you Please post some sample data in copiable format and also your expected output. It will help to provide you an accurate solution.
Hi,
I have this table1. and a calendar table shows all duration from earliest date form latest of table 1.
the calendar will be X-Aris.
thank you!
[Table 1]
Item Start Plan Start Actual Finish Plan Finish Actual TC1 13/09/2018 14/09/2018 07/12/2018 07/12/2018 TC2 13/09/2018 07/12/2018 TC3 13/09/2018 13/09/2018 07/12/2018 TC4 13/09/2018 07/12/2018 TC5 13/09/2018 17/09/2018 07/12/2018 TC6 13/09/2018 31/10/2018 07/12/2018 07/12/2018 TC7 13/09/2018 13/09/2018 07/12/2018 07/12/2018 TC8 13/09/2018 13/09/2018 07/12/2018 07/12/2018 TC9 13/09/2018 13/09/2018 19/12/2018 19/12/2018 TC10 20/09/2018 20/09/2018 19/10/2018 19/10/2018 TC11 20/09/2018 20/09/2018 19/10/2018 19/10/2018 TC12 20/09/2018 20/09/2018 23/10/2018 23/10/2018 TC13 20/09/2018 20/09/2018 23/10/2018 23/10/2018 TC14 20/09/2018 20/09/2018 23/10/2018 23/10/2018 TC15 20/09/2018 20/09/2018 23/10/2018 23/10/2018 TC16 20/09/2018 20/09/2018 24/10/2018 24/10/2018 TC17 20/09/2018 20/09/2018 24/10/2018 24/10/2018 TC18 20/09/2018 20/09/2018 01/11/2018 01/11/2018 TC19 20/09/2018 20/09/2018 01/11/2018 01/11/2018 TC20 20/09/2018 20/09/2018 01/11/2018 01/11/2018 This is what i created using quick new measure funtion
but i want the Y-asix as % and don't want the future lines apear ( gray and yellow lines)