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) )??
