Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Column to Identify Less than or equal to Today + 1 month

I want to add column to a table to Identify all rows that are <= Today() + 1 month.

I tried using 

DATEDIFF(Table[date], DATEAADD(TODAY(), 1 MONTH)

But I got error since DATEADD takes a series not a singe value.

how can I resolve this?

1 ACCEPTED SOLUTION
johnt75
Super User
Super User

You can get the date for today + 1 month with

Today + 1 month = DATE( YEAR(TODAY()), MONTH(TODAY()) + 1, DAY(TODAY()))

View solution in original post

1 REPLY 1
johnt75
Super User
Super User

You can get the date for today + 1 month with

Today + 1 month = DATE( YEAR(TODAY()), MONTH(TODAY()) + 1, DAY(TODAY()))

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.