This is a cool trick that goes hand in hand with Relative Month Index. It shows how to include a slicer that lets the user choose which month they want to start a 24 month look back in. Users love 12 or 24 month graphs that let them see history. But sometimes they want to choose the month they start their look-back from. Here’s how you do that with DAX and Disconnected Slicers. Credit goes to Brian Grant for the solution with a few modifications made by the rest of us along the way!
Let’s look at what a data lakehouse is, how it’s different from a data warehouse or data lake, the benefits of using one, and how it modernizes your processes.