Forum Discussion

JulianTobon's avatar
JulianTobon
Helper I
9 years ago

Function To Calculate Fiscal Week

Hi all,   I want to calculate the number of weeks based on the date of sale, I used the formula:  week = WEEKNUM(Scorecard[SalesDate],2) This works very well but not for what I need, Due to work ...
Need Help
Sean's avatar
Sean
Community Champion
9 years ago

VvelardeWhere's week 28?

Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

Sean

 

Yes, the formula need some adjustment.

 

WeeKFY2 =
VAR WeekStartinFY =
    WEEKNUM ( DATE ( Calendario[FiscalYear], 7, 1 ); 2 )
RETURN
    IF (
        Calendario[WeeK] < WeekStartinFY,
        WeekStartinFY + Calendario[WeeK],
        Calendario[WeeK] - WeekStartinFY
            + 1
    )

 

Now Appears.But don't know if this the solution to Julian's Question.