Recalculating Custom Collumn for new rows

Question

Hi Team,&nbsp;&nbsp;On a table, I have created a custom column that parses an existing column to get a part of the existing text.&nbsp;I have now appended more rows to this table and want the same column to parse for the newly added rows.&nbsp;&nbsp;What is the best way to do this?&nbsp;&nbsp;Thank you in advance.&nbsp;

ba_pete · Answer

Hi&nbsp;GMethnitis&nbsp;,
&nbsp;
In Power BI Desktop, you need to refresh preview in Power Query to update the preview window, or refresh the report to update the data model. Both refresh buttons are on the Home tab of their respective windows.
In the Power BI Service you will need to refresh the report dataset.
&nbsp;
Pete

anonymous · Answer

Hi&nbsp;GMethnitis&nbsp;,
&nbsp;
If everything is OK, just drag your step of your custom column&nbsp;to the latest from the applied steps
Applied steps - Power Query | Microsoft Learn.

&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Best Regards,
Stephen Tao
&nbsp;
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;

Forum Discussion

Recalculating Custom Collumn for new rows

2 Replies

Related content

Index multiple collumns

Stop Dataflow from Refreshing/Recalculating while Developing

Filter Only some Collumns with Calculate

Summarization of recalculated values

Customer Scorecard