Forum Discussion
Date Filters
johnt75 that article was very insightful. Would you have any idea how to apply that logic to my already made calculations? If that is not possible, would I have to delete my calculations and rebuild it based on the logic in that article. One part of the article that is unclear is:
how is the Period table related to the date table? specifically this part: The resulting table needs to be linked to Date through a bidirectional relationship so that a filter on Period is propagated first to Date, and then to Sales.
johnt75 that article was very insightful. Would you have any idea how to apply that logic to my already made calculations? If that is not possible, would I have to delete my calculations and rebuild it based on the logic in that article. One part of the article that is unclear is:
how is the Period table related to the date table? specifically this part: The resulting table needs to be linked to Date through a bidirectional relationship so that a filter on Period is propagated first to Date, and then to Sales.
I think you would probably have to redo your calculations to take account of how you're setting up the periods, either calculation groups or as a table.
You wouldn't necessarily need to use the config table method that SQLBI proposed, you could build the table in any way you wanted, perhaps a combination of GENERATETABLE, DATESBETWEEN and UNION could construct what you need.
The relationship from Period to Date needs to be bidirectional because the relationship is many-to-one from Period to Date, and a single direction relationship would mean that Date filters Period. You need to be able to place a filter on Period, e.g. using a slicer, and have Period filter Date.