To get the maximum month of the quarter

[Swamy3105]

Hi Experts,

I want to get the maximum month number from each quarter of the year.

ex:

Quarter       Month     Year

Q1                1            2019

Q1                2            2019

Q1                3            2019

Q2                4            2019

Result should be :

Q1 = 3

Q2 = 4

Please help.

[AlB · Accepted solution]

Hi @Swamy3105 

1. Place Year and Quarter in a table visual

2. Create this measure and place it on the tabel visual:

Measure = MAX(Table1[Month])