Select between a range

[Anonymous]

Hi there

I have a dimension called Promo FWeek

This starts from 201705 until 201728

I need to exclude Week 28

I have tired this but just not working

Plz assist urgently

=if([Promo FWeek]<201728, [Promo FWeek],)

Thnx so much