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
User | Count |
---|---|
51 | |
42 | |
25 | |
12 | |
10 |
User | Count |
---|---|
48 | |
36 | |
30 | |
13 | |
9 |