FanofExcel18
Board Regular
- Joined
- Jun 7, 2018
- Messages
- 65
I would like to create a Power BI Report to help with forecasting. Part of what I would like to see is the following based on an input of a specific date any user could enter. Not sure if that's possible in Power BI:
- Previous Year (Day) - Not the Date but the Day of the Week for the previous year. Date's move, a date previous year falls on a Sunday will be different this year which will be a Monday. Would want to see the previous year's 4th Monday of the month
- Previous Weeks Trend - The week before the date
- Previous Days Trend - Not sure the correct naming convention but similar to Previous Year (Day), I would like to show the last 3 Day of the Weeks. Example: Date falls on a Friday, show the last 3 Friday's prior's volume
Final Example:
I put in 9/7/2021 which is the 1st Tuesday of September
- Previous Year (Day) - Show 2020 1st Tuesday of September
- Previous Weeks Trend - Show 8/29 to 9/4
- Previous Days Trend - Show 8/31, 8/24, 8/17
Appreciate any insight into this
- Previous Year (Day) - Not the Date but the Day of the Week for the previous year. Date's move, a date previous year falls on a Sunday will be different this year which will be a Monday. Would want to see the previous year's 4th Monday of the month
- Previous Weeks Trend - The week before the date
- Previous Days Trend - Not sure the correct naming convention but similar to Previous Year (Day), I would like to show the last 3 Day of the Weeks. Example: Date falls on a Friday, show the last 3 Friday's prior's volume
Final Example:
I put in 9/7/2021 which is the 1st Tuesday of September
- Previous Year (Day) - Show 2020 1st Tuesday of September
- Previous Weeks Trend - Show 8/29 to 9/4
- Previous Days Trend - Show 8/31, 8/24, 8/17
Appreciate any insight into this