Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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.
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
102 | |
68 | |
45 | |
37 | |
37 |