Forum Discussion
arp2
1 year agoHelper II
Custom Fiscal Year error
I have a simple model in Power BI with two tables. I have a custom Fiscal Year Calendar Table which is Date Table. The FY starts in July and ends in June. The week starts on Saturday and ends on Frid...
- 1 year ago
arp2 - this will work for last week:
VAR LastWeekStart = SELECTEDVALUE ( FYCalendar[WeekStart] ) - 7 VAR LastWeekEnd = SELECTEDVALUE ( FYCalendar[WeekEnding] ) - 7 RETURN CALCULATE ( DISTINCTCOUNT ( MasterProjListR02[Project Number] ), REMOVEFILTERS ( FYCalendar ), MasterProjListR02[Project Creation Date] >= LastWeekStart, MasterProjListR02[Project Creation Date] <= LastWeekEnd )and your measure for YTD will already work:
see attached file
If I answered your question please mark my post as the solution, it helps others with the same challenge find the answer!
arp2
1 year agoHelper II
| Date | WeekEnding | MonthCutoff | FiscalYear | WeekStart |
| 6/29/2024 | 7/5/2024 | 7/26/2024 | FY25 | 6/29/2024 |
| 6/30/2024 | 7/5/2024 | 7/26/2024 | FY25 | 6/29/2024 |
| 7/1/2024 | 7/5/2024 | 7/26/2024 | FY25 | 6/29/2024 |
| 7/2/2024 | 7/5/2024 | 7/26/2024 | FY25 | 6/29/2024 |
| 7/3/2024 | 7/5/2024 | 7/26/2024 | FY25 | 6/29/2024 |
| 7/4/2024 | 7/5/2024 | 7/26/2024 | FY25 | 6/29/2024 |
| 7/5/2024 | 7/5/2024 | 7/26/2024 | FY25 | 6/29/2024 |
| 7/6/2024 | 7/12/2024 | 7/26/2024 | FY25 | 7/6/2024 |
| 7/7/2024 | 7/12/2024 | 7/26/2024 | FY25 | 7/6/2024 |
| 7/8/2024 | 7/12/2024 | 7/26/2024 | FY25 | 7/6/2024 |
| 7/9/2024 | 7/12/2024 | 7/26/2024 | FY25 | 7/6/2024 |
| 7/10/2024 | 7/12/2024 | 7/26/2024 | FY25 | 7/6/2024 |
| 7/11/2024 | 7/12/2024 | 7/26/2024 | FY25 | 7/6/2024 |
| 7/12/2024 | 7/12/2024 | 7/26/2024 | FY25 | 7/6/2024 |
| 7/13/2024 | 7/19/2024 | 7/26/2024 | FY25 | 7/13/2024 |
| 7/14/2024 | 7/19/2024 | 7/26/2024 | FY25 | 7/13/2024 |
| 7/15/2024 | 7/19/2024 | 7/26/2024 | FY25 | 7/13/2024 |
| 7/16/2024 | 7/19/2024 | 7/26/2024 | FY25 | 7/13/2024 |
| 7/17/2024 | 7/19/2024 | 7/26/2024 | FY25 | 7/13/2024 |
| 7/18/2024 | 7/19/2024 | 7/26/2024 | FY25 | 7/13/2024 |
| 7/19/2024 | 7/19/2024 | 7/26/2024 | FY25 | 7/13/2024 |
| 7/20/2024 | 7/26/2024 | 7/26/2024 | FY25 | 7/20/2024 |
| 7/21/2024 | 7/26/2024 | 7/26/2024 | FY25 | 7/20/2024 |
| 7/22/2024 | 7/26/2024 | 7/26/2024 | FY25 | 7/20/2024 |
| 7/23/2024 | 7/26/2024 | 7/26/2024 | FY25 | 7/20/2024 |
| 7/24/2024 | 7/26/2024 | 7/26/2024 | FY25 | 7/20/2024 |
| 7/25/2024 | 7/26/2024 | 7/26/2024 | FY25 | 7/20/2024 |
| 7/26/2024 | 7/26/2024 | 7/26/2024 | FY25 | 7/20/2024 |
| 5/31/2025 | 6/6/2025 | 6/27/2025 | FY25 | 5/31/2025 |
| 6/1/2025 | 6/6/2025 | 6/27/2025 | FY25 | 5/31/2025 |
| 6/2/2025 | 6/6/2025 | 6/27/2025 | FY25 | 5/31/2025 |
| 6/3/2025 | 6/6/2025 | 6/27/2025 | FY25 | 5/31/2025 |
| 6/4/2025 | 6/6/2025 | 6/27/2025 | FY25 | 5/31/2025 |
| 6/5/2025 | 6/6/2025 | 6/27/2025 | FY25 | 5/31/2025 |
| 6/6/2025 | 6/6/2025 | 6/27/2025 | FY25 | 5/31/2025 |
| 6/7/2025 | 6/13/2025 | 6/27/2025 | FY25 | 6/7/2025 |
| 6/8/2025 | 6/13/2025 | 6/27/2025 | FY25 | 6/7/2025 |
| 6/9/2025 | 6/13/2025 | 6/27/2025 | FY25 | 6/7/2025 |
| 6/10/2025 | 6/13/2025 | 6/27/2025 | FY25 | 6/7/2025 |
| 6/11/2025 | 6/13/2025 | 6/27/2025 | FY25 | 6/7/2025 |
| 6/12/2025 | 6/13/2025 | 6/27/2025 | FY25 | 6/7/2025 |
| 6/13/2025 | 6/13/2025 | 6/27/2025 | FY25 | 6/7/2025 |
| 6/14/2025 | 6/20/2025 | 6/27/2025 | FY25 | 6/14/2025 |
| 6/15/2025 | 6/20/2025 | 6/27/2025 | FY25 | 6/14/2025 |
| 6/16/2025 | 6/20/2025 | 6/27/2025 | FY25 | 6/14/2025 |
| 6/17/2025 | 6/20/2025 | 6/27/2025 | FY25 | 6/14/2025 |
| 6/18/2025 | 6/20/2025 | 6/27/2025 | FY25 | 6/14/2025 |
| 6/19/2025 | 6/20/2025 | 6/27/2025 | FY25 | 6/14/2025 |
| 6/20/2025 | 6/20/2025 | 6/27/2025 | FY25 | 6/14/2025 |
| 6/21/2025 | 6/27/2025 | 6/27/2025 | FY25 | 6/21/2025 |
| 6/22/2025 | 6/27/2025 | 6/27/2025 | FY25 | 6/21/2025 |
| 6/23/2025 | 6/27/2025 | 6/27/2025 | FY25 | 6/21/2025 |
| 6/24/2025 | 6/27/2025 | 6/27/2025 | FY25 | 6/21/2025 |
| 6/25/2025 | 6/27/2025 | 6/27/2025 | FY25 | 6/21/2025 |
| 6/26/2025 | 6/27/2025 | 6/27/2025 | FY25 | 6/21/2025 |
| 6/27/2025 | 6/27/2025 | 6/27/2025 | FY25 | 6/21/2025 |