Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

DAX Formula Help

Hi,

 

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

 

External IDProduct ConfiqurationDesired Output
1234Product AProduct A
12 Product A
12345 Product A
1234567Product BProduct B
12345667 Product B
12344 Product B
12Product CProduct C
1 Product C

 

  • Anonymous's avatar
    Anonymous
    4 years ago

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

     

     

4 Replies

  • VijayP's avatar
    VijayP
    Icon for Community Champion rankCommunity Champion

    Anonymous 

    What will be the desired output?!

  • VijayP's avatar
    VijayP
    Icon for Community Champion rankCommunity Champion

    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 !

    • Anonymous's avatar
      Anonymous
      Not applicable

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

       

       

  • VijayP's avatar
    VijayP
    Icon for Community Champion rankCommunity Champion

    Anonymous 

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