Forum Discussion

aliahad's avatar
aliahad
Frequent Visitor
1 year ago
Solved

Trying to get Max value using a column parameter

I have a table where I have added a column with an IF statment RowNumberYear = IF(VALUE(MAX('gt EMPLOYEE'[YEAR])) = VALUE('Head Count'[YEAR]), 1, 0) I am trying to get Max value using following...
  • Rupak_bi's avatar
    Rupak_bi
    1 year ago

    Hi aliahad ,

    I think Irwan s approach was correct and solves the ask. However, to be specific, considering there is only month and year column, the solution will be as below.

    If this solves, Plz accept as solution

aliahad's avatar
aliahad
Frequent Visitor
1 year ago

Hi Irwan ,

 

I tried the expression you provided, it gives me the 'MAX' for all the rows in the dataset.

 

So in my dataset I have a column 'MONTH' and 'YEAR' and I need to get a calculated column that gives me 1 for 'MAX' month and 'MAX' year, and 0 for all the remainder rows. The current dataset got max year as 2025 and max month as 5, and in my column I need 1 for MAX year 2025 and MAX month 5 and 0 for remainder of the rows. This should switch when the June data is added to the dataset.

 

I hope I have clarify the ask.

 

Thanks,

Ali.

Rupak_bi's avatar
Rupak_bi
Super User
1 year ago

Hi aliahad ,

I think Irwan s approach was correct and solves the ask. However, to be specific, considering there is only month and year column, the solution will be as below.

If this solves, Plz accept as solution