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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
srykhanna
New Member

Need help in DAX, a hard problem.

 

Can you please help how to achieve this using DAX?

 

Column AColumn B
10=10
1212 - Sum(Previous Output) = 12 - 10 = 2
13 13 - Sum(Previous Output) = 13 - (2 + 10) = 1
1414 - Sum(Previous Output) = 14 - (1 + 2 + 10) = 1
1 ACCEPTED SOLUTION
ryan_mayu
Super User
Super User

@srykhanna 

you can try to create an index column in PQ

then use DAX to create columns

Column = if('Table'[Index]=1,'Table'[columnA],'Table'[columnA]-maxx(FILTER('Table','Table'[Index]=EARLIER('Table'[Index])-1),'Table'[columnA]))

Column 2 = if('Table'[Index]=1,'Table'[columnA],'Table'[columnA]-sumx(FILTER('Table','Table'[Index]<EARLIER('Table'[Index])),'Table'[Column]))

1.png

pls see the attachment below





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

1 REPLY 1
ryan_mayu
Super User
Super User

@srykhanna 

you can try to create an index column in PQ

then use DAX to create columns

Column = if('Table'[Index]=1,'Table'[columnA],'Table'[columnA]-maxx(FILTER('Table','Table'[Index]=EARLIER('Table'[Index])-1),'Table'[columnA]))

Column 2 = if('Table'[Index]=1,'Table'[columnA],'Table'[columnA]-sumx(FILTER('Table','Table'[Index]<EARLIER('Table'[Index])),'Table'[Column]))

1.png

pls see the attachment below





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors