Forum Discussion
mukdo
3 years agoFrequent Visitor
table with date filter between date range
I have two Table and there are no relationship between them. One table (FilterTable) has one column Months. Another Table (DateRangeTable) have some column like StartDate , EndDate. Where date ranges...
NikhilChenna
3 years agoSkilled Sharer
Hi mukdo ,
It is simple. You have use create a date dimension table and create one to many relationship with both the tables. and then use montth slicer from the date table it should work.
Regards,
Nikhil Chenna
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!