Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
@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.
Proud to be a PBI Community Champion
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)
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |