Hello,
I have a data set which contains opening and closing value for a particular end time, I have to show Max of closing value for a month and a date .
First measure is based on month :-For example, in below data set for month of 'Nov', Max of End time is 21:00:00.0000 for date '2019-10-30' and closing balance is 5676.43 , so for month of 'NOV' it should give '5676.43'
Second measure is based on Date :- If user selects Date as '2019-11-25', it should return max value of end time for this date that is '10687.71.
I have to show these values in a line chart with two dimensions:- Month and Date and above two measures.
So upon selection of Month and date it will display values.
| End time | Closing value | Opening value | Date | Financial month |
| 2019-11-25 19:00:00.0000 | 10646.406 | 7968.174 | 2019-11-25 | Nov |
| 2019-11-25 19:00:00.0000 | 13093.776 | 10809.864 | 2019-11-25 | Nov |
| 2019-11-25 20:00:00.0000 | 18038.217 | 13001.079 | 2019-11-25 | Nov |
| 2019-11-25 20:00:00.0000 | 28487.371 | 17938.82 | 2019-11-25 | Nov |
| 2019-11-25 21:00:00.0000 | 6557.804 | 12594.826 | 2019-11-25 | Nov |
| 2019-11-25 21:00:00.0000 | 10275.308 | 17922.32 | 2019-11-25 | Nov |
| 2019-11-25 21:00:00.0000 | 10687.71 | 20213.281 | 2019-11-25 | Nov |
| 2019-10-31 21:00:00.0000 | 5676.43 | 6543654 | 2019-11-30 | Nov |
Please suggest.
