DAX Formula Help

[united2win]

Hi,

Is there a DAX formula that can give me the desired output in this table?

External ID	Product Confiquration	Desired Output
1234	Product A	Product A
12		Product A
12345		Product A
1234567	Product B	Product B
12345667		Product B
12344		Product B
12	Product C	Product C
1		Product C

[VijayP]

@united2win 

If you can share exact sample data , then solution might be accurate

[VijayP]

in power query editor right click on the product column and select fill-> down to get the desired result!

Earlier it was not clear since you kept both problem statement and solution in same place !

[united2win · Accepted solution]

Hi thanks for the solution, but it appears it doesn't work.

[VijayP]

@united2win 

What will be the desired output?!