Forum Discussion
Custom Comparison Period calculations not working correctly in visuals with dates
Hello, i have a dashbaord that is using a comparison date table, the configuration is such that Im able to select any custom dates to compare my current date range with. Im then calculating % increas...
You’re on the right track by using a second date table and inactive relationship for custom comparisons, but to achieve the month-to-month shift logic you're after, consider adjusting your DAX to dynamically align month offsets using alternatives or shifting with . You might also find a Real Estate Survey helpful when modeling comparative time data structures in broader applications. Let me know if you'd like a more refined measure suggestion!