DAX Question MAX Date Record

[SNik]

Hi This is a DAX question i have 2 tables and they are
tblA has a one to many relation with tblB   tblB is a Fct table and tblA a Dim table
TblA (DIM)
aKey  , aName , ....
   1       a
    2     b
 
tblB (FCT)
bKey  aKey   bName    bDate (number format)   fieldA   Field B
  1        1          b 1        20120101                          1            2
  2        1          b 1        20130101                          3            4
  3        2          b 2        20090101                          1            0
  4        2          b 2        20160101                          3            2
 
 
 
How can i get a table output using DAX with the result of the
  1- the last date for each record
  2- If Field A> Field B then "Red" else "Green"
 
  2        1          b 1        20130101     GREEN
  4        2          b 2        20160101     RED
 
I need the DAX for that , Thanks

 and do i add the DAX in the FCT of the DIM ?

I am using Excel 2013 PowerPivot

[Greg_Deckler]

You can add a custom column in your dimension table like:

MAX(RELATED(Fact[bDate]))

[SNik]

how can i do that?

must i use the DAX in the Fact?

can you help me is in the step by step?, i dont need the details as long as i can understand the steps more i'll follow and find out myself

thanks

Please help more