Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 :
Please find in attachment the pbix sample file.
Can you help me solve it ?
Many thanks.
@Greg_Deckler @amitchandak @Ashish_Mathur
Abdoullah
Solved! Go to 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 )
)
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 )
)
Tables cannot read the filter context. Ot won't automatically update on selection
Do you need to add this index as a column? Then how does the table look like?
@tamerj1
Not as a column but as slicer.
Will be linked later with a DIM_Calendar table based on the values.
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |