Forum Discussion
Last 5 weeks show value as 1
Hi Experts
need a calculated column measure to show one if the date is in the last 5 weeks. See image i have the following calculated column measure but it goes beyond 5 weeks, based on todays date and week num
and try this
Column = IF([Date] <= TODAY()&&[Date] >= TODAY()-30,1,0)
4 Replies
- Idrissshatila
Super User
Hello Anonymous ,
try instead of <= use >=
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote for my Community Mobile App Idea 💡 - Ahmedx
sorry this corrected cod
Column = VAR _CurrentWeek = WEEKNUM(TODAY(),2) VAR _WeekNumber = WEEKNUM([Date],2) RETURN IF(_WeekNumber<=_CurrentWeek&&_WeekNumber>=_CurrentWeek-4,1,0)- Ahmedx
and try this
Column = IF([Date] <= TODAY()&&[Date] >= TODAY()-30,1,0)
