SWITCH for 2 different date columns

Click here to downlaod a solution from one drive.

Look at the documentation on all pages, on the relationships and inside the dax measures

Please click thumbs up and accept solution button. Thank you

Click here 

Hi joshua1990,

Thank you for providing information on your issue. I’ve reviewed your scenario and successfully replicated it using sample data on my end.

I’m sharing the working .pbix file below so you can explore the setup and DAX logic more clearly. Please feel free to open it and review how the relationships and measures are configured:

I hope this helps resolve your issue. If you have any questions or need further clarification, I’m happy to help.

If you found this post useful, kindly give it a ‘Kudos’ and mark it as a solution so others facing similar challenges can find it more easily.

Thanks for being part of the Microsoft Community!