Automatically update others rows data when same KPI data updated

Hi Team
I am building one Power APP and I have data like below
Forecast field users should update and I have thousands of KPIs. The forecast is the same for all months for one KPI.
For example, the KPI ABC forecast is the same for 12 months i.e. GREEN
But the requirement is, that users should not update the forecast of one KPI 12 times. Once updated in January, in SQL Table, that KPI forecast should be automatically updated from Feb to Dec.
Power App Data.xlsx (9.6 KB)

Hi @PijushRoy ,

While waiting for the community to review and respond to your issue, take advantage of Data Mentor . It offers a wealth of tools and resources that could provide immediate solutions and enhance your report-building efficiency.


Enterprise DNA Support Team