Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello all!
I have a data model and fairly basic sales grid that shows sales this year and, utilizing the Sameperiodlastyear function, shows last year Sales. In PowerBI, it works fine, but when I connect to the data model via Excel, it doesn't seem to understand how to show the last year numbers. I'd like for some folks to use this model to do basic ad-hoc reports, but this seems to be a deal breaker for using Excel. Any ideas?
PBI:
Excel (Last year blank):
Solved! Go to Solution.
Sorry for wasting your time - I was using the week number field from the data table instead of the calendar table. it's working now
Hi @ffunky
I just tested it and it works fine on my side, would you mind sharing your dummy pbix that I can dig it further ?
Sorry for wasting your time - I was using the week number field from the data table instead of the calendar table. it's working now
Hi @ffunky
Great to know you have fixed it, please kindly mark the answer as solution to finish the thread. thanks a lot!
User | Count |
---|---|
77 | |
75 | |
67 | |
65 | |
47 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |