Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
103 | |
90 | |
78 | |
72 | |
68 |
User | Count |
---|---|
108 | |
96 | |
95 | |
74 | |
71 |