Creating an automatic column

[Anonymous]

Hello ! 

As part of a professional project, I would need to create an automation for adding a column.
Let me explain.
Currently to create this column that does not exist on our dataset, we click on the new column button and we put a LookupV function with a formula that includes the table or we retrieve the information that will be in this column.
My manager wants me to optimize that, automating and making sure that when we refresh this column it increments.
Ideally it should avoid the manip create a column

[jdbuchanan71]

Your LOOKUPVALUE column is the calculated column.  Whenever the model is refreshed the calculated columns are re-calculated.

[jdbuchanan71 · Accepted solution]

Is there someting not working in your column?  That will get updated every time the model is refreshed so new entries will be popuplated.

[Anonymous]

how ? can you please tell me how you created it ?

[jdbuchanan71]

Please share an example of the two tables.  Paste the text, not a screen shot of the tables.  Show what field you are trying to add from one to another.

[Anonymous]

this is the loockupV I use : ClientList = LOOKUPVALUE(ClientAll[GTPS_CompileClientsList],ClientAll[BDR ID],V_REPORT_ALL_CRS_INFO[BDR_ETP_ID].

[jdbuchanan71]

It sounds like you use the table in multiple datasets and you have to add this column each time, correct?  You could create the table in a dataflow where you add the column as part of the transformation, then you would get the table from the dataflow for each new dataset and the column would already be there.

https://learn.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-introduction-self-ser...

[Anonymous]

Hello ! 

Thank you so much for your answer, but no, I dont use this table in multiple datasets, I use two tables, and i need to add a column for only one, but nby using informations from anther, i use a LoockupV but i am looking for a better solution, and a solution to visualize it also