Automate Weekly Data

[amitchandak · Accepted solution]

@Anonymous , You want to calculate Source or show or both, You want to see this year's data with the complete month as a month and the rest as a week?

In case you have date you can get like

Source = if([Date] <=eomonth(today(),-1), "Month", "Week")

Show = if([Date] >=date(year(today()),1,1) && [Date] <= today(), "Yes", "No")

Or create a date with month year to use above