Forum Discussion
Helper IIIMember Join and Expiry dates, using one date table and enabling accurate drillthroughs.
Helper IIIThank you - I had managed to get this far by myself, but the issue I am having is that when using the time function (so the month-year, for example) from the date table - only the one with the active relationship will actually work properly.
If I want two active date relationships to take full advantage of the date/time features of a date table, do I need to split these two columns out from the table and link them separately? Or is there an alternative method that I could use?
In the demonstration above that is what you have done, whereas my issue appears to be that both join & expiry are within the same table.
Hi, twofingertyper
Without splitting into two tables, I think it would be better to add the Expiry column directly to the Rows of the matrix instead of adding Date[Date].
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum