March 6, 2020
MDX, 29 февраля и Parallelperiod
Неплохой кейс, пишут что эффективный.
union ( PARALLELPERIOD( [Date].[Fiscal Detail].[Fiscal Year],1, [Date].[Fiscal Detail].currentmember) *(will be null if Feb 29)* , PARALLELPERIOD( [Date].[Fiscal Detail].[Fiscal Year],1, [Date].[Fiscal Detail].currentmember.lag(1)) *(will be the prior year Feb 28 when above is Feb 29 )* ).item(0) *(get the first member out of the union set)*