Using DATEADD and NOW() together

dax
whytheq picture whytheq · Apr 13, 2016 · Viewed 11.2k times · Source

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.

Answer

WalTig picture WalTig · Apr 19, 2018

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()
    )

Related questions

how to convert a Integer to Text value in Power BI

I am creating a calculated column in existing power BI report. the calculated column concatenates integer & text columns. I tried below query which give syntax error to me, = Number.ToText(table1.[RegionID]) & " " & table1.[RegionName] I tried some …

Read More
How to format new measure (not column) in power BI as percentage?

When I create a new measure with formula, i.e. sum(col1)/max(col2), it automatically converts the result into #.#% format. Strangely, it doesn't happen all the time; sometimes it just gives result #.## format. Any idea of how to format …

Read More
How to get month name from month number in Power BI?

I have Year number and Month Number in my data. How using DAX can I get the month name out of month number? In SSRS its very easy. But how to achieve that using DAX?

Read More