cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

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

2 REPLIES 2
Super User
Super User

Re: Dates Running Total/ % Running total

@colourfullife 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.



Did I answer your question? Mark my post as a solution !

Proud to be a Datanaut !





Highlighted

Re: Dates Running Total/ % Running total

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]

ItemStart PlanStart ActualFinish PlanFinish Actual
TC113/09/201814/09/201807/12/201807/12/2018
TC213/09/2018 07/12/2018 
TC313/09/201813/09/201807/12/2018 
TC413/09/2018 07/12/2018 
TC513/09/201817/09/201807/12/2018 
TC613/09/201831/10/201807/12/201807/12/2018
TC713/09/201813/09/201807/12/201807/12/2018
TC813/09/201813/09/201807/12/201807/12/2018
TC913/09/201813/09/201819/12/201819/12/2018
TC1020/09/201820/09/201819/10/201819/10/2018
TC1120/09/201820/09/201819/10/201819/10/2018
TC1220/09/201820/09/201823/10/201823/10/2018
TC1320/09/201820/09/201823/10/201823/10/2018
TC1420/09/201820/09/201823/10/201823/10/2018
TC1520/09/201820/09/201823/10/201823/10/2018
TC1620/09/201820/09/201824/10/201824/10/2018
TC1720/09/201820/09/201824/10/201824/10/2018
TC1820/09/201820/09/201801/11/201801/11/2018
TC1920/09/201820/09/201801/11/201801/11/2018
TC2020/09/201820/09/201801/11/201801/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)

what i have.PNG