You’re offline. This is a read only version of the page.
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?
Share
Report
All responses (
Answers (
638
