Forum Discussion
eliasayyy
Memorable Member
3 years agocreate a dynamic selection slicer that affects date slicer
hello everyone i have a normal calendar table and another table called selection table i made a measure Filter Latest Month For SP =
SWITCH(
SELECTEDVALUE('Period Se...
- 3 years ago
ok i just created a new table
Test Dynamic Table = UNION( SELECTCOLUMNS( FILTER('Calendar', 'Calendar'[Date] >= TODAY() - WEEKDAY(TODAY(), 2) + 1 && 'Calendar'[Date] <= TODAY()), "Date", 'Calendar'[Date], "Type", "Current Week", "Order", 1 ), SELECTCOLUMNS( FILTER('Calendar', 'Calendar'[Date] >= DATE(YEAR(TODAY()), MONTH(TODAY()), 1) && 'Calendar'[Date] <= TODAY()), "Date", 'Calendar'[Date], "Type", "Current Month", "Order", 2 ), SELECTCOLUMNS( FILTER('Calendar', 'Calendar'[Date] >= DATE(YEAR(TODAY()), INT((MONTH(TODAY()) - 1) / 3) * 3 + 1, 1) && 'Calendar'[Date] <= TODAY()), "Date", 'Calendar'[Date], "Type", "Current Quarter", "Order", 3 ), SELECTCOLUMNS( FILTER('Calendar', 'Calendar'[Date] >= DATE(YEAR(TODAY()), 1, 1) && 'Calendar'[Date] <= TODAY()), "Date", 'Calendar'[Date], "Type", "Current Year", "Order", 4 ), SELECTCOLUMNS( FILTER('Calendar', 'Calendar'[Date] >= DATE(YEAR(TODAY()) - 1, 1, 1) && 'Calendar'[Date] <= DATE(YEAR(TODAY()) - 1, 12, 31)), "Date", 'Calendar'[Date], "Type", "Last Year", "Order", 5 ), SELECTCOLUMNS( FILTER('Calendar', 'Calendar'[Date] >= MIN('Calendar'[Date]) && 'Calendar'[Date] <= MAX('Calendar'[Date])), "Date", 'Calendar'[Date], "Type", "Custom", "Order", 6 ) )
made a relationship between my new table and calendar table from "Date" Column and szet it to both and it worked
eliasayyy
Memorable Member
3 years agook i just created a new table
Test Dynamic Table =
UNION(
SELECTCOLUMNS(
FILTER('Calendar', 'Calendar'[Date] >= TODAY() - WEEKDAY(TODAY(), 2) + 1 && 'Calendar'[Date] <= TODAY()),
"Date", 'Calendar'[Date],
"Type", "Current Week",
"Order", 1
),
SELECTCOLUMNS(
FILTER('Calendar', 'Calendar'[Date] >= DATE(YEAR(TODAY()), MONTH(TODAY()), 1) && 'Calendar'[Date] <= TODAY()),
"Date", 'Calendar'[Date],
"Type", "Current Month",
"Order", 2
),
SELECTCOLUMNS(
FILTER('Calendar', 'Calendar'[Date] >= DATE(YEAR(TODAY()), INT((MONTH(TODAY()) - 1) / 3) * 3 + 1, 1) && 'Calendar'[Date] <= TODAY()),
"Date", 'Calendar'[Date],
"Type", "Current Quarter",
"Order", 3
),
SELECTCOLUMNS(
FILTER('Calendar', 'Calendar'[Date] >= DATE(YEAR(TODAY()), 1, 1) && 'Calendar'[Date] <= TODAY()),
"Date", 'Calendar'[Date],
"Type", "Current Year",
"Order", 4
),
SELECTCOLUMNS(
FILTER('Calendar', 'Calendar'[Date] >= DATE(YEAR(TODAY()) - 1, 1, 1) && 'Calendar'[Date] <= DATE(YEAR(TODAY()) - 1, 12, 31)),
"Date", 'Calendar'[Date],
"Type", "Last Year",
"Order", 5
),
SELECTCOLUMNS(
FILTER('Calendar', 'Calendar'[Date] >= MIN('Calendar'[Date]) && 'Calendar'[Date] <= MAX('Calendar'[Date])),
"Date", 'Calendar'[Date],
"Type", "Custom",
"Order", 6
)
)
made a relationship between my new table and calendar table from "Date" Column and szet it to both and it worked