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
JulianTobon's avatar
JulianTobon
Helper I
9 years ago

Phil_Seamark My data skip dates, because not every day we receive purchases. Example Date/Calendar table:

 

 

In Power BI

 

Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

JulianTobon

 

 

Hi, please try this calculated column in your table and let me know

 

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