Forum Discussion

MCacc's avatar
MCacc
Helper 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

NikhilChenna's avatar
NikhilChenna
Skilled Sharer
3 years ago

Hi MCacc , I think below is the solution for you.

 

1. Create a summarize table in power bi , select the modelling tab and select the new table option.

 

Summarize_table=
SUMMARIZE(
    'table1',
    'table1'[QUARTER],
    "MaxMonth",MAX('table1'[MONTH]),
    "Maxcode",MAX('table1'[CODE]),
    "MaxInfo",MAX('table1'[INFO])
)
 
this will solve your issue.
 
Regards, 
Nikhil Chenna
 
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!