Power BI guide
Fiscal YTD Power BI: fix TOTALYTD for financial-year reporting
If your Power BI YTD sales or fiscal year-to-date figures restart in January, the measure is using calendar-year logic. The fix is a marked Date table plus a YTD measure that passes the correct fiscal year-end date.
Quick answer
For fiscal YTD Power BI measures, use TOTALYTD or DATESYTD with the fiscal year-end argument. October-September years use "09-30". April-March UK financial years use "03-31". The Date table must also have matching fiscal year and fiscal month fields.
The production DAX pattern
Start with a base measure, then wrap it in TOTALYTD with the right year-end date.
Sales Amount =
SUM('Sales'[SalesAmount])
Fiscal YTD Sales =
TOTALYTD(
[Sales Amount],
'Date'[Date],
"09-30"
)That example is for an October-September financial year. For an April-March UK fiscal year, change the third argument to "03-31".
Why Power BI year-to-date goes wrong
Most broken fiscal YTD reports have one of these problems:
- The model uses Power BI's hidden Auto Date/Time table instead of a real Date table.
- The YTD measure omits the fiscal year-end argument, so January becomes the default start.
- Visuals use calendar month fields while the measure uses fiscal logic.
- Month labels are sorted alphabetically rather than by fiscal month number.
Fiscal year-end cheat sheet
| Financial year | Power BI year-end argument | Common use |
|---|---|---|
| October to September | "09-30" | Education, charities, public-sector reporting |
| April to March | "03-31" | UK financial-year reporting |
| July to June | "06-30" | Some global and academic reporting cycles |
| January to December | omit the argument | Calendar-year reporting only |
Safer DATESYTD pattern
For more control, use CALCULATE with DATESYTD. This makes the filter behaviour easier to extend for prior-year, variance, and rolling-period measures.
Fiscal YTD Sales =
CALCULATE(
[Sales Amount],
DATESYTD('Date'[Date], "09-30")
)How to validate the result
- Create a table with Fiscal Year, Fiscal Month Name, Fiscal Month Num, and the YTD measure.
- Sort Fiscal Month Name by Fiscal Month Num.
- Check that October starts at month 1 for an October-September year.
- Confirm the YTD measure resets after September, not after December.
- Compare one month against a finance export before publishing.
Related fixes
If the fiscal YTD measure is right but the visual still looks wrong, fix Power BI month sorting. If the Date table itself is missing fiscal columns, start with the full fiscal year Power BI guide. If the issue comes from inconsistent transaction dates, old ERP extracts or fields that changed during a system move, review the data management support and data migration support pages before adding more report logic.
Fiscal YTD Power BI FAQs
What does fiscal YTD mean in Power BI?
Fiscal YTD means year-to-date based on the organisation's financial year, not the calendar year. For an October-September year, the YTD period starts on 1 October and resets after 30 September.
Why is my Power BI YTD sales measure wrong?
The common cause is a TOTALYTD measure with no fiscal year-end argument. Power BI then assumes a calendar year and restarts the calculation in January.
Can TOTALYTD handle UK financial years?
Yes. Use TOTALYTD([Measure], 'Date'[Date], "03-31") for an April-March UK financial year, supported by a proper Date table.
Need this checked in a live model?
Digital Adaption reviews Power BI models for UK SMEs, including fiscal calendars, YTD measures, month sorting, and dashboard trust issues. When the YTD issue is caused by bad source dates, weak master data or a system change, the next step is a data management review or migration readiness check.
Book a Power BI review