How to compare period N with N-1 in Excel dynamically?
🎥 Check out our presentation video, which reveals the essential technique for comparing two periods N and N-1 in Excel! ⏳📊
📎 Training link: https://excel-exercice.com/downloads/...
In this demonstration, you will learn step by step how to:
🗂️ Structure your data to make it usable with a PDC
📥 Load your data into the Power BI data model
🗓️ Build a time table
🎁 (Bonus) Link the time table to the dates in your model
🔗 Create the links between the tables
📈 Create the measures to compare period N with N-1