dsum in power bi?!

[chen_shany]

hi, 

i have a table in DW that is updated every month.

how can I use DAX for summarizing "product a" for the most updated date?

date	product a	product b
01/01/2018	69	500
01/01/2018	1669	5221
01/01/2018	0	128
01/01/2018	0	0
01/02/2018	0	129
01/02/2018	69	500
01/02/2018	1668	5220
01/02/2018	0	0
01/03/2018	1666	5222
01/03/2018	0	127
01/03/2018	69	497
01/03/2018	0	0
01/04/2018	1661	5221
01/04/2018	69	497
01/04/2018	0	127
01/04/2018	0	0
01/05/2018	1661	5221
01/05/2018	69	497
01/05/2018	0	127
01/05/2018	0	0

[Phil_Seamark · Accepted solution]

HI @chen_shany

I think this calculated measure will work for the data as you present it.  I have attached a PBIX file that shows this and also a measure that works with Product B.  However I recommend you pivot your data around so that Products are in rows and not columns.

Most Updated Product A = 
    MAXX(
        FILTER(
            'Table1',
            'Table1'[product a]=MAX('Table1'[product a])
            ),
        'Table1'[date]
        )