Forum Discussion

Colin_Davis's avatar
Colin_Davis
Frequent Visitor
1 year ago
Solved

MAX value with Filter or If

I want to create a New Column that contains True, if this is the higest version for this user, for this course, and the status is completed.  I have the following table called Main:   User Name ...
  • bhanu_gautam's avatar
    bhanu_gautam
    1 year ago

    Colin_Davis , Create a new column using

     

    DAX
    Highest Version =
    VAR CurrentUser = 'Main'[User Name]
    VAR CurrentCourse = 'Main'[Course Title]
    VAR CurrentVersion = 'Main'[Version]
    RETURN
    IF(
    'Main'[Status] = "Completed" &&
    CurrentVersion =
    CALCULATE(
    MAX('Main'[Version]),
    FILTER(
    'Main',
    'Main'[User Name] = CurrentUser &&
    'Main'[Course Title] = CurrentCourse &&
    'Main'[Status] = "Completed"
    )
    ),
    TRUE,
    BLANK()
    )

bhanu_gautam's avatar
bhanu_gautam
Icon for Super User rankSuper User
1 year ago

Colin_Davis , Create a new column using

 

DAX
Highest Version =
VAR CurrentUser = 'Main'[User Name]
VAR CurrentCourse = 'Main'[Course Title]
VAR CurrentVersion = 'Main'[Version]
RETURN
IF(
'Main'[Status] = "Completed" &&
CurrentVersion =
CALCULATE(
MAX('Main'[Version]),
FILTER(
'Main',
'Main'[User Name] = CurrentUser &&
'Main'[Course Title] = CurrentCourse &&
'Main'[Status] = "Completed"
)
),
TRUE,
BLANK()
)

  • Colin_Davis's avatar
    Colin_Davis
    Frequent Visitor
    1 year ago

    Thank you, it returns True/False, I don't know why "Blank()" isn't returned, but I can use it.  
    Thank you very much.