Forum Discussion

Anonymous

Not applicable

7 years ago

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

Icon for Community Champion rank

Community Champion

7 years ago

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.

Anonymous

Not applicable

7 years ago

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)