Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi Team,
I have 3 tables
DepartmentTable | ||
Dept_ID | DeptName | |
1 | HR | |
2 | Finance | |
3 | IT | |
4 | KYC | |
5 | Sales | |
Dept_ID (Identity) | ||
Dept_ID Primary Key |
2)
College Branch | ||
College ID | CollegeName | City |
100 | SBC | Pune |
101 | ABC | Delhi |
102 | HIND | Kolcatta |
103 | CUBE | Chennai |
104 | Forum | Banglore |
College ID (Identity) | ||
College ID Primary Key |
3)
RevenueTable | |||||
RevID | Dept_ID | College ID | Revenue | Date | UpdatationDatetime |
1 | 1 | 100 | 100 | 11/1/2021 | 11/1/2021 |
2 | 2 | 101 | 105 | 11/2/2021 | 11/2/2021 |
3 | 3 | 102 | 110 | 11/3/2021 | 11/3/2021 |
4 | 4 | 103 | 120 | 11/4/2021 | 11/4/2021 |
5 | 5 | 104 | 130 | 11/5/2021 | 11/5/2021 |
6 | 1 | 100 | 140 | 11/6/2021 | 11/6/2021 |
7 | 2 | 101 | 150 | 11/7/2021 | 11/7/2021 |
8 | 3 | 102 | 160 | 11/8/2021 | 11/8/2021 |
9 | 4 | 103 | 170 | 11/9/2021 | 11/9/2021 |
10 | 5 | 104 | 180 | 11/10/2021 | 11/10/2021 |
RevID (Identity) | |||||
College_ID Foreign Key | |||||
College_ID Foreign Key |
Requirment- I want to create a form to insert/update/delete records to the Revenue table by using power apps.
in the power apps with to create a dropdown selection with Deptname, college name and City
eg. once user select the "HR" and SBC and Pune from the dropdown then user should add the revenue value(500) and date(2021-11-11) in the textbox
then automatically it will insert the record in the Revenue table As
RevID | Dept_ID | College ID | Revenue | Date | UpdatationDatetime |
11 | 1 | 100 | 500 | 11/11/2021 | 11/26/2021 14:23:343 |
Thanks,
@Anshenterprices , I think the question is for the power app? Not for power bi?
refer if this can help
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
76 | |
69 | |
54 | |
37 | |
35 |
User | Count |
---|---|
86 | |
68 | |
59 | |
51 | |
46 |