I need to fill a column with a value based on a single row

Question

I need to fill a column based on one rows value.  This row is an aggregate based on a measure code.   I took a screen shot of the current set up.  I was thinking of using the create rows tool, but I cannot figure out how to do that based on a condition.  So basically in the example is one measure but I have several measures.  The value in the row is for the ADE measure only.  So for all dates for that particular measure I need to fill it with the Basline information that is in one row. I hope that makes sense.  I am having a hard time articulating the question.

Christina_H · Answer

This seems like a good use for an append tool, or join if you have different values for different accounts.  Filter out the rows with the data you want, then join or append it to all rows.  I've also used a unique tool since you have more than one row for the same date.

aberthiaume · Answer

when I union them back together it just creates the same issue.

FloraF · Answer

Hi,

You are able to do so by the multi field formula, you can select the group by, there are couple of steps that has to be done before that though; such as: filtering the data and then sorting. You may add a union after the manipulation to bring in the historical data and stack on top of the 2022 data. Please see the attached file.

**If this solves the issue, please click on the like below" thank you!**

* Happy Solving

multi row formula.yxzp