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.
Hello All,
I'm trying to create some forecast but I notice that have an issue with February and could use some help. I have a date field, a column with data at the end of the month and a forecast column. I have the visual filtered to only show the end of month. My formula for the forecast is:
Forecast = CALCULATE([Measure], SAMEPERIODLASTYEAR(DateTable[date_field]))
As you can see there 02/28/21 does not have data for the forecast because the previous February end date is 02/29/2020. Moving forward that could create an issue when we have the next leap year. Is there a way to solve this?
Solved! Go to Solution.
Instead of using SAMERPERIODLASTYEAR, I used PARALLELPERIOD and that seemed to work.
Instead of using SAMERPERIODLASTYEAR, I used PARALLELPERIOD and that seemed to work.
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 |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |