Forum Discussion
Helper IIIMember Join and Expiry dates, using one date table and enabling accurate drillthroughs.
Hi, twofingertyper
I use the following relationship between tables and it will work by using the measure. You can try this.
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
twofingertyperThank 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 TeamIf 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