Forum Discussion
Solved
DAX Formula Help
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 |
Hi thanks for the solution, but it appears it doesn't work.
4 Replies
What will be the desired output?!
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 !
Hi thanks for the solution, but it appears it doesn't work.
If you can share exact sample data , then solution might be accurate
