Forum Discussion
Date range filter use only in calculation but not table visual
hi everyone, I have one problems where I have a date range filter in my report using transaction date in Db. this filter is not impacting the table visual as in I edit interaction and select None for...
Deku
Super User
Super UserCant comment without having a understanding of your semantic models structure
hi Deku , let me share my report structure.
I have one table with leave transaction details and a custom table where I create the calendar table
MonthYearTable =
ADDCOLUMNS (
CALENDAR(DATE(2025, 1, 1), DATE(2030, 12, 31)), -- Define your date range
"MonthYear", FORMAT([Date], "YYYYMM"), -- Format as "Month Year"
"SortOrder", YEAR([Date]) * 100 + MONTH([Date]) -- Create a sortable value (e.g., 202101 for Jan 2021)
)
this 2 table is linked via leavetable.transactiondate = monthyeartable.date
then i used the monthyear column in a slicer. from there I would like to get the date range and use it in my calculation. hope you get what im trying to do