Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
colourfullife
Post Partisan
Post Partisan

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
PattemManohar
Community Champion
Community Champion

@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 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]

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.