cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JPSCHAFFER
Frequent Visitor

DAX Solution Needed: Copy until next value

I posted this before but the solution didn’t work.

 

I need DAX formula to create the values in the last column. The value in the [MAKE OR BUY] column would trigger the change to the value in [PART NO], and carry that until the next change.

 

Capture.PNG

 

 

 

2 REPLIES 2
Anonymous
Not applicable

Does it have to be dax, or could you use power query. Seems easier in Power Query, just create a conditional column that if Make or Buy = Make the Part No else null. Then you can just fill down

Anonymous
Not applicable

Yeah, PQ is the right place to do it.

 

Best

Darek

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors