2 what-if parameter connected using generateseries

[ATTAR]

Hello all,

I am trying to connect two parameters to each other. 

The first one is called "Day" as it contains day range from 1 to 31.

The second one is called "Index" and should be connected to the "Day" parameter with the following logic as shown in the screenshot. 

For example :

• If the Day parameter is set on 15 which is higher than 9 (as in 9 June) then my range would start from -12 to -1 
  
  
• If the Day parameter is set on 3 which is lower than 9 (as in 9 June) then my range would start from -13 to -2

Please find in attachment the pbix sample file. 

Can you help me solve it ? 

Many thanks.

@Greg_Deckler  @amitchandak @Ashish_Mathur 

Abdoullah 

[tamerj1 · Accepted solution]

Hi @ATTAR 
Another way of doing that is as follows https://we.tl/t-rEUCEmyA59

Index = 
GENERATE (
    Parameter,
    VAR CurrntValue = Parameter[Parameter]
    VAR DayOfToday = DAY ( TODAY ( ) )
    VAR IndexStart = IF ( CurrntValue <= DayOfToday, -13, -12 )
    VAR IndexEnd = IF ( CurrntValue <= DayOfToday, -2, -1 )
    RETURN 
        GENERATESERIES ( IndexStart, IndexEnd, 1 )
)

[tamerj1]

@ATTAR 

You may try this approach with two filter  tables

https://youtu.be/TufnsAxJsjs

[tamerj1]

@ATTAR 

Tables cannot read the filter context. Ot won't automatically update on selection 

[tamerj1]

@ATTAR 

Do you need to add this index as a column? Then how does the table look like?

[ATTAR]

@tamerj1 
Not as a column but as slicer. 

Will be linked later with a DIM_Calendar table based on the values.