Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |