Forum Discussion
Filtering a table in a cascading relationship
- 6 years ago
hi AlexKahler
From your screenshot of relationship, it should works well.
I think the problem should be that
Master Date table is used DAX, so it will only have 12:00:00AM time for each date,
[Visit date & time] must have different time not just 12:00:00AM time for each date,
you just change the format of them to make them same.
So although you have create a relationship between them, but they are not same for each date.
Just add a date column for [Visit date & time]
Date = DATE(YEAR([Visit date & time]),MONTH([Visit date & time]),DAY([Visit date & time]))Then use this column to create a relationship instead of [Visit date & time].
Now it should work well.
Regards,
Lin
hi AlexKahler
From your screenshot of relationship, it should works well.
I think the problem should be that
Master Date table is used DAX, so it will only have 12:00:00AM time for each date,
[Visit date & time] must have different time not just 12:00:00AM time for each date,
you just change the format of them to make them same.
So although you have create a relationship between them, but they are not same for each date.
Just add a date column for [Visit date & time]
Date = DATE(YEAR([Visit date & time]),MONTH([Visit date & time]),DAY([Visit date & time]))
Then use this column to create a relationship instead of [Visit date & time].
Now it should work well.
Regards,
Lin
Hi,
Thanks a lot! This solved the issue.
I made a custom column as you described and it work perfectly!