How to get latest target as per month

[komald]

I have data which consist columns like salesperson name, target, revision no. as so on
revision no. indicates the updated target for that particular month.
Now what im looking for , I want to create a matrix which show month wise initial and revised target i.e last target for that month w.r.t sale person. 
revised target nothing but latest target of that sales person in that particular month
and initial target is first target of that sales person in that particular month
for e.g 
salesperson  date          Target     revision no
a                   2 march    3k               1

a                   2 march    5k               2

a                   4 Apr         4k              1

a                   4 apr          7k              2
a                   5 apr         6k              3
output: in the form of metrix
month                           march                                                 apr
salesperson        initial target |  Revised target         initial target |   Revised target

   a                           3k                  5k                                 4k                    6k

[tamerj1 · Accepted solution]

Hi @komald 

you may try

Revised target =
CALCULATE (
    MAX ( 'Table'[Target] ),
    'Table'[revision no] = MAX ( 'Table'[revision no] )
)

initial target =
CALCULATE ( MAX ( 'Table'[Target] ), 'Table'[revision no] = 1 )