calculate the fiscal week, but getting duplicates

[nick9one1]

Can anyone help with this? 

I'm trying to calculate the fiscal week, but getting duplicates. 

Fiscal Week Num = 
VAR _FiscalWeekStart = 27
RETURN
    IF (
        NickDimDate[Week] >= _FiscalWeekStart,
        ( NickDimDate[Week]  ) - ( _FiscalWeekStart - 1 ),
        52 + ( NickDimDate[Week]  ) - ( _FiscalWeekStart - 1 )
    )

[RemyO]

Your DAX seems ok

First row = 52 + 1 - 27 + 1 = 27

Second Row = 53 - 27 + 1 = 27

So its not your DAX that isnt working but it seems the formula you are using isnt doing what you expect.