I have two dimensions Key and Date and one measure sales.Each key has one date and null values. The problem is sales data is available only for null value.
| Key | Date | Sales |
|---|
| 101 | 1-09-2017 | _ |
| 101 | _ | 232 |
| 101 | _ | 321 |
| 102 | _ | 654 |
| 102 | _ | 342 |
| 102 | 1-10-2017 | _ |
I want to show both date(Excluding nulls) and max(sale) for the keys in the table.
The issue is if i filter null values for date i get null for max (sales) because sales data is only available for null dates,How do i show both max(sales) and date together in table.
Can i do some 'aggregation' on date over key so that i dont exclude null dates(maybe something like Aggr(Date(Max(Date)),Key) )??
