Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

The MAX function only accepts a column reference as an argument

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 

 

 

 

 

  • VahidDM's avatar
    VahidDM
    4 years ago

    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/

     

     

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

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

    • VahidDM's avatar
      VahidDM
      Icon for Super User rankSuper User
      4 years ago

      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/