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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
sajjadkhan25
Helper I
Helper I

Need to add all years in series

Hi @amitchandak sir & everyone,

 

Greeting for the day!!

i need dax or power query where i need result has shown in image. please help me on this

 

sajjadkhan25_0-1658841079137.png

Thanks and Regards,

Sajjad 

1 ACCEPTED SOLUTION
AntonioM
Solution Sage
Solution Sage

You could add a custom column

 

Column = CONCATENATEX(FILTER('Table', [Column1] <= EARLIER('Table'[Column1])), [Column1])
 
AntonioM_0-1658843736576.png

 

 

View solution in original post

1 REPLY 1
AntonioM
Solution Sage
Solution Sage

You could add a custom column

 

Column = CONCATENATEX(FILTER('Table', [Column1] <= EARLIER('Table'[Column1])), [Column1])
 
AntonioM_0-1658843736576.png

 

 

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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