Forum Discussion
Class66Loco
Advocate I
Advocate ILookup function?
Hello, Table A a Project ID column and Table B has a column which references the Table A Project ID column. Its a one to many relationship where the Project ID is listed once in Project A and is ...
If you add a date dimension and connect to both tables, when you filter the date in the date dimension both tables will be filtered to the same date range
Khushidesai0109
Skilled Sharer
Skilled SharerClass66Loco
Filtered Table B Measure =
VAR SelectedMinDate = MIN('Table A'[Date])
VAR SelectedMaxDate = MAX('Table A'[Date])
RETURN
IF(
SELECTEDVALUE('Table B'[Date]) >= SelectedMinDate &&
SELECTEDVALUE('Table B'[Date]) <= SelectedMaxDate,
1,
0
)