Forum Discussion
Solved
Fiscal YTD calculation using DATESYTD get 50% result wrong.
BillUnitsMonthly = CALCULATE(SUM(MonthlyReport[Subscript]),
ALL('Calendar'[FiscalYear]),
'Calendar'[FiscalYearNo]<=MAX('Calendar'[FiscalYearNo])
)
BillUnits FYTD = CALCULATE([BillUnitsMonthly],DATESYTD('Calendar'[Date],"31/3"))
The .pbix file can be download from the link.
https://1drv.ms/u/s!ArFNhSS94KaIgp8s2FoB6XK-ws-hrw
pls try this
BillUnitsMonthly = CALCULATE(SUM(MonthlyReport[Subscript]), REMOVEFILTERS(),VALUES('Calendar'[FiscalMonth]), 'Calendar'[FiscalYearNo]<=MAX('Calendar'[FiscalYearNo]) )
