Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |