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
  • rubayatyasmin's avatar
    rubayatyasmin
    2 years ago

    Here you go

     

    AddP4 rows.pbix53 KB
rubayatyasmin's avatar
rubayatyasmin
Community Champion
3 years ago

Hi, dsj8wksnnckk 

 

I have reproduced your problem and was able to solve it. 

Need to transform. I am adding the pbix file. 

AddP4 Rows.pbix

 

Result:

 

 

 

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 😞

      • rubayatyasmin's avatar
        rubayatyasmin
        Community Champion
        2 years ago

        sure. I will upload it once I get home