Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to Solution.
You can get the date for today + 1 month with
Today + 1 month = DATE( YEAR(TODAY()), MONTH(TODAY()) + 1, DAY(TODAY()))
You can get the date for today + 1 month with
Today + 1 month = DATE( YEAR(TODAY()), MONTH(TODAY()) + 1, DAY(TODAY()))