Forum Discussion

MCacc's avatar
MCacc
Icon for Helper IV rankHelper IV
3 years ago
Solved

Help with a max condition

Hello,    I have a table with the following information   The columns Code and Info are what I want to show in my visual   Quarter column corresponds to a field from a calendar table with...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi MCacc ,

     

    You could create a calculated column in table:

    ismax = 
var max_date = MAXX(ALLEXCEPT('Table','Table'[QUARTER]),'Table'[MONTH])
return
IF('Table'[MONTH]=max_date,1,0)

    Then add it to visual filter and set value = 1.

     

    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi MCacc ,

 

You could create a calculated column in table:

ismax = 
var max_date = MAXX(ALLEXCEPT('Table','Table'[QUARTER]),'Table'[MONTH])
return
IF('Table'[MONTH]=max_date,1,0)

Then add it to visual filter and set value = 1.

 

Best Regards,

Jay