Forum Discussion
anandfarmers
2 years agoAdvocate I
ALLSELECTED() - data modelling issue
Hi All, I have the below schema The DatePeriod can be Yesterday, This Week, This Month, etc. So a Date can be in multiple Date Periods. Date Period has Many to One relationship with D...
lbendlin
2 years agoSuper User
Date Period has Many to One relationship with DimDate.
yes, but the search filter goes both ways, making this rather ineffective. Cut the link and use measures instead.
anandfarmers
2 years agoAdvocate I
Thanks lbendlin .
The users need to be able to filter by Date Period. e.g. This week, this month, etc. So they don't need to enter dates - that is the requirement.
I cannot use a measure as a Slicer.