Forum Discussion

Isnaan_Ahmed's avatar
Isnaan_Ahmed
Frequent Visitor
3 years ago

Help with Time Intelligence using Fiscal Years

Hi all!   Hope you can help with an issue I'm having - I am trying to create a table that lists the ordered units by Fiscal Year (this part works) with another column showing ordered units in the p...
FreemanZ's avatar
FreemanZ
Super User
3 years ago

hi Isnaan_Ahmed 

try like:

_OrderedUnits Last FY =
VAR _SelectedFY = SELECTEDVALUE ( _FiscalDates[Fiscal Year (544)]  )
RETURN
    CALCULATE(
        [01. Ordered Units],
        _FiscalDates[Fiscal Year (544)] = LEFT(_SelectedFY, 2)&(RIGHT(_SelectedFY,2)-1)
)