AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
5.2K members online now
5.2K members online now
Ask questions about Data Studio
Guide Me

can you do this with dates in date studio??

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Question is how to calculate the % of the month gone and % remaining

Eg today is the 12th may So it needs to know that may has 31 days And today is the 12th


With Adwords we normally report on last full day So I need a formula that identifies the month. The number is days in that month. The current day And divides those


Reason being for budget calculations

Eg spent 1100 so far. So likely to spend 3100 this month