AlexBartlett
Participant
3 weeks, 2 days ago
Hi,
I have a Fabric Planning Sheet using the measures in rows layout with:
Rows: SKU
Columns: Month
Value: Planning input measure
For example:
| SKU | Measure | Jul-26 | Aug-26 | Sep-26 | Oct-26 | Nov-26 | Dec-26 |
| SKU001 | Sales | 100 | 100 | 100 | |||
| Forecast Input Measure | 100 | 100 | 100 | ||||
| SKU002 | Sales | 150 | 150 | 150 | |||
| Forecast Input Measure | 150 | 150 | 150 |
I need users to bulk edit this data, ideally by exporting a template, changing values, and importing it through PowerTable.
The issue is:
- Excel export contains the Planning input measure.
- CSV export gives me the vertical SKU + Date structure I want, but doesn't include the input measure.
- InfoBridge can produce exactly SKU/date/Input Measure, but I can't see how to expose/export that query through PowerTable or automatically keep a PowerTable populated from it.
- I don't want a second Planning Sheet/input measure because that creates another copy of the data to synchronise.
Ideally I need:
Planning input measure
↓
SKU | Date | Input Measure
↓
PowerTable / export template
↓
bulk edit
↓
PowerTable import
Is there a supported way to synchronise a PowerTable from a Planning input measure or InfoBridge query, or otherwise provide an exportable bulk-edit template containing the current input-measure values?
Many thanks,
Alex
Up
1
2 Replies
Gopal KrishnamurthyLumel Staff
Founder/CEO · Lumel Technologies Inc · 2 weeks, 4 days ago
It is in our immediate roadmap and we have started working on it. The bulk input capability will be more robust/comprehensive than what we had in Inforiver WB Matrix.
Up
0
Viewing 2 replies - 1 through 2 (of 2 total)
