Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
Greetings,
OK, so I have spent significant time trying to figure this out and I just can't seem to get anything to work. If this has been answered I have had no luck finding an answer.
I have a table that sums enrollment by the number of days prior to the first day of classes. I have data for the current term being registered for and in this case the previous year’s enrollment by the same countdown value. This way we are comparing enrollment to the same number of days prior to the first day of classes for each year. Please see the example data below.
In Power BI I can produce this:
Below is an example of what I need to create. That is two additional columns for "Difference" between 2023 and 2024 and the "Percent difference" between 2023 and 2024. The programming is dynamic so the next iteration will become 2024 and 2025. In other words, the Year values are not static so I cannot use the "2023" and "2024" values in any DAX.
Thank you all for your time and help,
Gary
Hey @Noogin ,
please create a pbix file containing sample data that still reflects your data model (tables, relationships, calculated columns, and measures). Upload the pbix to OneDrive, Google Drive, or Dropbox and share the link. If you are using a spreadsheet to create the sample data instead of the manual input data share she spreadsheet as well.
Regards,
Tom
Hey Tom,
I believe I have the link to my Dropbox here: for an example of what I am trying to do.
Thanks!
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
| User | Count |
|---|---|
| 16 | |
| 13 | |
| 8 | |
| 8 | |
| 5 |
| User | Count |
|---|---|
| 30 | |
| 27 | |
| 25 | |
| 24 | |
| 24 |