Complement values to a defined value

[dsj8wksnnckk]

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 my formula to check if the SUM of duration from Table1 is 60 (in this case) and if not, complement it with P4 and duration needed to achive the SUM of 60.

Please note that P4 can appear in Table 1 and that I need this output in table or matrix that can be sorted by Resources.

Thanks all for help!

[rubayatyasmin]

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]

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]

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]

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

[rubayatyasmin · Accepted solution]

Here you go

[rubayatyasmin]

sure. I will upload it once I get home