Share
ReportI'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:
I have the same question (0)
All responses (
Answers (
519
