cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
neryfrederico Frequent Visitor
Frequent Visitor

Combine differents scenarios

Hello, everyone!

 

I have the follow data sets.

 

Real Sales until last month;

 JanFevMarAbr.MaiJunJulAgostSetOctSetNovDec
Store 11091098        
Store 21091098        
Store 31091098        

 

Budget1

 JanFevMarAbrMai.JunJulAgostSetOctSetNovDec
Store 1     33333333
Store 2     33333333
Store 3'    33333333

 

Budget2

 JanFevMarAbr.Mai.JunJulAgostSetOctSetNovDec
Store 1     55555555
Store 2     55555555
Store 3'    5555555

5

 

Budget3

 JanFevMarAbr.MaiJunJulAgostSetOctSetNovDec
Store 1     77777777
Store 2     77777777
Store 3'    77777777

 

 

Is possible that I give the user the possibility to select the budget (scenario) dynamically and visualize how the store will performe? 

 

Thank you in advance.

 

Ex.:

      Budget 1Budget 2Budget 2Budget 3Budget 3Budget 3Budget 3Budget 3
 JanFevMarAbr.MaiJunJulAgostSetOctSetNovDec
Store 1109109835577777
Store 2109109835577777
Store 310910983557777

 

7

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Combine differents scenarios

@neryfrederico 

  1. Create a seperate table for with Store e.g Store1, 2, ..
  2. Create both 1:* relationship between these tables 
  3. you can give this view using Table/ Metrix as per your preference
1 REPLY 1

Re: Combine differents scenarios

@neryfrederico 

  1. Create a seperate table for with Store e.g Store1, 2, ..
  2. Create both 1:* relationship between these tables 
  3. you can give this view using Table/ Metrix as per your preference

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 52 members 1,208 guests
Please welcome our newest community members: