DAX Question MAX Date Record

SNik — Tue, 05 Jul 2016 19:05:37 GMT

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

Re: DAX Question MAX Date Record

Greg_Deckler — Wed, 06 Jul 2016 14:01:56 GMT

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

MAX(RELATED(Fact[bDate]))

Re: DAX Question MAX Date Record

SNik — Thu, 07 Jul 2016 01:02:19 GMT

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

topic Re: DAX Question MAX Date Record in Developer

DAX Question MAX Date Record

Re: DAX Question MAX Date Record

Re: DAX Question MAX Date Record