Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Note: Source Sheet is the bottom and Target one is the top
Problem1. Red arrow the same with the stock code but when I replaced each item it will delete the formula encircled in amber circle thereby not generating the stock code number and Stock Item. It also needs to add rows automatically while source sheet is being updated. Need some suggestion
Problem2. Auto-populate the target sheet while the source sheet is being but the catch is the days and day rate of several rows interchange. It also needs to add rows automatically while source sheet is being updated. Need some suggestion
Problem 3. Can the automation be done via excel especially if the rows involved hundred of thousands? Will new commands need to be written everytime an automation will be needed?
Looking forward to hear from the community..
Hi
there are several problems in this post so I need to address the priority one.
If a text has been introduced in the target sheet taken from the source sheet that match the stock code then it will trigger the appropriate stock item. stock items are stored on another excel sheet and only linked to the target sheet.
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 |
---|---|
17 | |
9 | |
8 | |
7 | |
7 |