topic Re: The MAX function only accepts a column reference as an argument in DAX Commands and Tips

The MAX function only accepts a column reference as an argument

Anonymous — Wed, 08 Dec 2021 15:50:55 GMT

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

Re: The MAX function only accepts a column reference as an argument

Anonymous — Wed, 08 Dec 2021 15:42:45 GMT

amitchandak or VahidDM could you please help me on this code

Re: The MAX function only accepts a column reference as an argument

VahidDM — Thu, 09 Dec 2021 04:43:46 GMT

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/

Re: The MAX function only accepts a column reference as an argument

Anonymous — Thu, 09 Dec 2021 05:37:37 GMT

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...