Forum Discussion
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...
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
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