DAX SUM OF COUNT

[SNik]

Hi

I have a question, i have ...

Date                  Name     Colour     Value

2016-01-01      A             R               100

2016-01-01      B             G               100

2016-01-02      A             B               200

2016-01-02      C             R               200

2016-01-03      B             B               300

and so on

I need a DAX to return me the mentioned per month

2016-01-02      A             B               200

2016-01-02      C             R               200

2016-01-03      B             B               300

I need the last date grouped by name in DAX

Thanks

[NikhilChenna]

Hi @SNik ,

I think the above is possible by using creating a new summarize table, go to modelling tab and click on new table option.

Summarized_table5 =

SUMMARIZE(

'Table (5)',

'Table (5)'[Name],

"Max Color",MAX('Table (5)'[Color]),

"Max Value",MAX('Table (5)'[Value] ))

This will solve you issue.

Regards,

Nikhil Chenna

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!