Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I thought this would be easy....
I have 2 fiscal years of data:
Mar 1, 2015 - Feb 29, 2016 = F2016
Mar 1, 2018 - Feb 28, 2019 = F2019
All I'm trying to do is calculate the % increase between these two years. (for sales, GP$, vehicle count, etc...)
I've tried parallelperiod but it just gives me same values for F2016, and nothing for F2019?!
This gives the same result as PARALLELPERIOD.
@Anonymous can you share your .pbix file?
Yes, can you walk me through how to do that?
I can't share my original file but I made a mock-up on that I can share. Both formulas come up with blank values so I figure if that issue gets solved I can try to apply it to my actual model.
The easiest way is to put it in OneDrive or DropBox then post the link here.
Like that?
Thank you for your help, I REALLY appreciate your time!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
83 | |
70 | |
65 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |