The MAX function only accepts a column reference as an argument

[Anonymous]

While creating calcualted column:

could youplease help me how to use max for single values.... max accepts only column instead of value 

_MeqY2 =

// then If(([USAGE_DATE]<=Max(DateAdd("dd",Day(DateTimeNow()),[SelectedMonthYear]))) and ([USAGE_DATE]>=Max(DateAdd("mm",-5,DateTimeNow()))),"Y","N")

var adddays = DAY(TODAY()) + [_SelectedMonthYear]

var last5 = DATE(YEAR(TODAY()), MONTH(TODAY())-5,1)

return

IF( 'Usage Tracking'[USAGE_DATE] <= MAX(adddays) && 'Usage Tracking'[USAGE_DATE] >= MAX(last5),1,0)

// DateAdd("dd",Day(DateTimeNow()),[SelectedMonthYear]))

-==================

while creating measure : usagedate is not accepting 

[Anonymous]

@VahidDM  you are right, but if i want to find the MAX variables days and  last 6 months, then how to do it? im using max as per migration project code....

using this calculated column i have write another final calculation based on

_MeqY2 cals

you are solution works superb...

[Anonymous]

@amitchandak  or @VahidDM  could you please help me on this code

[VahidDM · Accepted solution]

Hi @Anonymous 

You don't need to use MAX in your dormula, remove Max and just type your Variable names.

Try this:

_MeqY2 =
VAR adddays =
    DAY ( TODAY () ) + [_SelectedMonthYear]
VAR last5 =
    DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ) - 5, 1 )
RETURN
    IF (
        'Usage Tracking'[USAGE_DATE] <= adddays
            && 'Usage Tracking'[USAGE_DATE] >= last5,
        1,
        0
    )

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/