Getting Token Eof Expected Error in PowerBI

I'm trying to build a custom column in PowerBI to capture # of projects with project date < 30 days. The goal is to create a visual to see # projects with closed dates within 30 days of today. Here is the formula I have:

Within 30 Days of Project Closed Date = IF('Table'[Project Closed Date].[Date]>= TODAY(),IF('Table'[Project Closed Date].[Date] <=TODAY()+30, "Within 30 Days of Project Closed Date","No"))

Where am I going wrong?

Categories:

General Questions