Forum Discussion

dsj8wksnnckk's avatar
dsj8wksnnckk
Resolver I
3 years ago
Solved

Complement values to a defined value

Hi all, I'm trying to figure out how to solve the following challenge. I have these two tables with data   What I want to achieve is the following:   Short explanation: I ...
Need Help
dsj8wksnnckk's avatar
dsj8wksnnckk
Resolver I
3 years ago

Hey,

thanks for the assistance.

I'm not quite sure this solution would be applicable. I see one of your steps is transpose table, but my table will have unlimited number of rows (thats what the 3 dots mean on the bottom).

What do you think?

rubayatyasmin's avatar
rubayatyasmin
Community Champion
3 years ago

Hey, If you check it again, those were the automated steps that PQ performed. I took a sheet not a table when importing data to PBI PQ. So those were the unnecessary steps. 

See below image: 

 

 

these steps are the main ones. I did not use transpose. I loaded the tables and the result is same. 

 

 

  • dsj8wksnnckk's avatar
    dsj8wksnnckk
    Resolver I
    2 years ago

    Hey, can you re-upload the file? It was deleted and I seem to have lost it 😞