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.
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
Yeah, PQ is the right place to do it.
Check out new user group experience and if you are a leader please create your group!
Check out how to claim yours today!
Test your skills now with the Cloud Skills Challenge.