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
| Project Number | Project Name | Project Creation Date |
| 123 | ProjName1 | 7/30/2018 |
| 124 | ProjName2 | 2/25/2016 |
| 125 | ProjName3 | 3/20/2018 |
| 126 | ProjName4 | 11/7/2018 |
| 127 | ProjName5 | 6/26/2019 |
| 128 | ProjName6 | 2/14/2016 |
| 129 | ProjName7 | 10/27/2020 |
| 130 | ProjName8 | 7/29/2024 |
| 131 | ProjName9 | 7/29/2024 |
| 132 | ProjName10 | 7/29/2024 |
| 133 | ProjName11 | 7/29/2024 |
| 134 | ProjName12 | 7/29/2024 |
| 135 | ProjName13 | 7/29/2024 |
| 136 | ProjName14 | 6/17/2025 |
| 137 | ProjName15 | 7/29/2024 |