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

null
    • BI Project
    • Alister_Hill
    • 5 yrs ago
    • Reported - view

    Well, I think I solved it:

     

    {Tail({ { ADDCALCULATEDMEMBERS([Dates].[Year].LEVELS(1).ALLMEMBERS) } - { [Dates].[Year].& } },1)}

Login to reply

Content aside

  • Status Answered
  • 5 yrs agoLast active
  • 1Replies
  • 22Views
  • 1 Following