Forum Discussion

franorio's avatar
franorio
Helper III
9 years ago
Solved

Help cracking the formula for new column

Hello everybody, 

I got a column called ¨Name¨ with the # of order, in this report an order has as many rows as produts the client bought. 

All information as subtotal, date of order, status, currency, etc is shown for all the items of the same order, in the first row of the first item.

Would like to create a new column in which the fulfillment status is shown for al items in all rows according to this first order row.

 

For example: this is how i got the information now:

 

 

this is how the new column should get the data for al items with the same # of order

 

 

 

Any ideas to get this? Formulas, columns?

Should be for example something like if #12211 in Column: ''name'', has X status in Column: ''Fulfillment Status'', add new Column: ''All Status'' where all orders #12211 get the same status as ''Fulfillment Status''.

 

This should be done for aprox 30k rows

 

Any ideas?

 

Thanks!!

  • franorio if it were me I'd just use the Fill Down function in Query Editory - select the column, go to the Transform tab, and select Fill Down.  Would something like that work?  Every time the query runs it'll dynamically update your data in PBI.

     

     

    Dan

2 Replies

  • franorio if it were me I'd just use the Fill Down function in Query Editory - select the column, go to the Transform tab, and select Fill Down.  Would something like that work?  Every time the query runs it'll dynamically update your data in PBI.

     

     

    Dan