0
Removing blank member from set [SSAS Tabular 2017]
Hi,
When using the Time Intelligence wizard, the Last 3 years also includes an empty member.
This is a cube/MDX thing rather than Pyramid 2018 specifically, but if anyone knows how to remove this it would be great. Screenshots attached:
{Tail({ { ADDCALCULATEDMEMBERS([Dates].[Year].LEVELS(1).ALLMEMBERS) } },3)}
Returns: "2018","2019",""
But I would like "2017","2018","2019"
Many thanks,
Alister
1 reply
-
Well, I think I solved it:
{Tail({ { ADDCALCULATEDMEMBERS([Dates].[Year].LEVELS(1).ALLMEMBERS) } - { [Dates].[Year].& } },1)}