If I try adding the following Measure into my DimDate table:
Past6Months =
IF(
FIRSTDATE( 'Dates'[FullDate] ) >= DATEADD( NOW(), -7, MONTH ),
TRUE(),
FALSE()
)
I get this error:
The first argument to 'DATEADD' must specify a column.
What also works: do what DAX is asking you to do. First put TODAY
in a column and than refer to that column.
TodayColumn = TODAY()
Past6Months =
IF(
FIRSTDATE( 'Dates'[FullDate] ) >= DATEADD( 'MyTable'[TodayColumn], -7, MONTH ),
TRUE(),
FALSE()
)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With