Forum Discussion
Solved
Creating a Month overview based on multiple date columns
Hi Community I have been scaling previous solutions/youtube etc but can't find anything that will work for what I'm trying to do. I have a dataset with 3 date columns pertaining to Received/Appro...
Cfielding Using 3 separate date tables is a workable solution. If you use a single date table, then you will want to create the active and inactive relationships but use CALCULATE and USERELATIONSHIP to specify the correct relationship. Both of these methods are discussed in Mastering Power BI 2nd Edition.
Greg_Deckler Thanks for that - I'd used the USERELATIONSHIP in an earlier test, but realise I was still telling it to use the Active relationship instead of the inactive one...