Forum Discussion

ThomasBP's avatar
ThomasBP
Frequent Visitor
7 years ago

problem_New_year_calculs_refresh

Hello,      I was wondering, in one of my calcul for the current week I put: Semaine_en_cours = WEEKNUM(TODAY()) So since 2018, I have all the current weeks auto calculated.    For today, the f...
Need Help
Show and Tell
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi ThomasBP

try this measure instead of your formula

you could replace "DATE( )" with today( )

Measure 2 = var week1=WEEKNUM(DATE(2018,12,31),2) return IF(week1>52,1,week1)

 

Best Regards

Maggie