I have a measure with aggregation as Dis

Written by GSSV. Posted in Comments

I have a measure with aggregation as DistinctCount and a Date dimension with a hierarchy - Year->Quarter->Month->Date For any selected Date Level, we need to get the distinct count of the last date of the level. Say viewing the results at Year, it should consider only those of the Year last date and perform a distinct count A Month, should get distinct count of the last day . Please help me out. Thanks