Best practices for structuring rows and columns in a Planning sheet

Started by Sofia Martínez · 4 months ago · 1 reply · 11 views

Sofia Martínez Participant

4 months ago

I'm building my first Planning sheet from scratch. Our model has Accounts (rows) and Time periods (columns) with a Scenario dimension. Should Scenario be a column or a separate dimension? What's the canonical way to structure this?

2 Replies

Sort

Raj Subramaniam

Microsoft Fabric Consultant · CloudBridge Solutions · 2 days, 12 hours ago

Scenarios should be a separate dimension in your semantic model, not a column. This lets the Planning sheet operate on one scenario at a time (selected via a filter) while the Intelligence sheet can compare across scenarios. Making Scenario a column loses a lot of comparison flexibility.

Up

0