Forum Discussion

dogt1225's avatar
dogt1225
Helper III
5 years ago

Fiscal Year Week over Week

I am looking to show the fiscal week over week change.  The image below show the current data I am getting with my calculations, but there is an error at the start of a new Fiscal Year. The area I'v...
Need Help
manikumar34's avatar
manikumar34
Solution Sage
5 years ago

dogt1225 

Try something like this

Submitted Previous Week = 
     Calculate(Req[Submitted Date (Count)],
        FILTER(ALL('Calendar'),
        if(WEEKNUM(MAX('Calendar'[Date]))=1,
         'Calendar'[Fiscal Week Num] = Calculate(MAX('Calendar'[Fiscal Week Num]),ALL(Calendar)) &&
            'Calendar'[Fiscal Year] = VALUE(MAX('Calendar'[Fiscal Year])-1),
        'Calendar'[Fiscal Week Num] = VALUE(WEEKNUM(('Calendar'[Date)) - 1 )&&
            'Calendar'[Fiscal Year] = VALUE(MAX('Calendar'[Fiscal Year]))
        )
     )
)