Forum Discussion

asfdwd's avatar
asfdwd
Frequent Visitor
3 years ago
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([BillUnit...
Need Help
  • Ahmedx's avatar
    Ahmedx
    3 years ago

    pls try this

    BillUnitsMonthly = CALCULATE(SUM(MonthlyReport[Subscript]),
REMOVEFILTERS(),VALUES('Calendar'[FiscalMonth]),
'Calendar'[FiscalYearNo]<=MAX('Calendar'[FiscalYearNo])
)
Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
3 years ago

pls try this

BillUnitsMonthly = CALCULATE(SUM(MonthlyReport[Subscript]),
REMOVEFILTERS(),VALUES('Calendar'[FiscalMonth]),
'Calendar'[FiscalYearNo]<=MAX('Calendar'[FiscalYearNo])
)
asfdwd's avatar
asfdwd
Frequent Visitor
3 years ago

Not understand the logic behind it. But this code works perfectly for my report!

Thank you.