Forum Discussion

arp2's avatar
arp2
Helper II
1 year ago
Solved

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...
Need Help
  • mark_endicott's avatar
    mark_endicott
    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!

     

v-kpoloju-msft's avatar
v-kpoloju-msft
Community Support
1 year ago

Hi arp2,

Thank you for reaching out to the Microsoft fabric community forum. Also thanks to mark_endicott, for his insights on this thread. I reproduced the scenario, and it worked on my end. I used my sample data and successfully implemented it. Used line chart.

outcome:

I am also including .pbix file for your better understanding, please have a look into it:

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you for using Microsoft Community Forum.

  • arp2's avatar
    arp2
    Helper II
    1 year ago

    v-kpoloju-msft thanks for the reply. The Projects Created Last Week works perfectly, however, YTD is showing 6 whereas Projects YTD are 7. You may check and revert so that we can learn an alternative way otherwise Mark has already provided the solution.