Forum Discussion
two tables with dates one filter
Hi, I tried to get along with the forum but I failed, maybe you can help me: I have a Table with actions which took place on spereate dates in specific regions: Actiontable: Action 1 - 01/01...
You can either use a bucketing-approach: https://blogs.msdn.microsoft.com/analysisservices/2014/06/05/bucketing-values-in-dax/
or create a calculated table in DAX which expands your lookup-table with one row per date. Then you have a 1:1-relation with your Actiontable (Order-table in the example) and a 1:n to your date-table: http://www.thebiccountant.com/2016/12/01/analyzing-events-with-a-duration-in-dax-further-simplification/
You can create a new table with this formula
Table = DISTINCT( UNION( DISTINCT(TableA[Date]) ; DISTINCT(TableB[Date]) ))
And then, create the relashionship with your two tables.
You can create a new table with this formula
Table = DISTINCT( UNION( DISTINCT(TableA[Date]) ; DISTINCT(TableB[Date]) ))
And then, create the relashionship with your two tables.