Forum Discussion

ebrownretail's avatar
ebrownretail
Resolver I
2 years ago
Solved

Show Currenet Week

I am trying to get a visual to show me what my current week number is. I have a DATES table that has the correct fiscal week numbers already listed, but i am not sure how to bring the fiscal week num...
Need Help
  • ebrownretail's avatar
    ebrownretail
    2 years ago

    I was just able to figure something out for this!

     

    Curr WK # =
    CALCULATE(MAX(Dates[Fiscal Week]),FILTER(Dates,Dates[Date] = TODAY()))
     
    This will tell you what your current week# is based on today's date. Just wanted to share
Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

Hi,

Does this measure work?

Week number of today = calculate(max(Dates[Week number]),datesbetween(Calendar[date],today(),today()))
ebrownretail's avatar
ebrownretail
Resolver I
2 years ago

Hi! i am getting this error. Any ideas how to fix this error?