Rank = RANKX(ALLEXCEPT(‘Account Level AUM’,’Account Level AUM'[InvestmentAccountLegalName],’Account Level AUM'[InvestmentAccountNumber],’Account Level AUM'[InvestmentAssetClassTypeName],’Account Level AUM'[AssetCategoryName],’Account Level AUM'[AccountBaseCurrencyCode],’Account Level AUM'[ListingUID],’Account Level AUM'[InstrumentUID],’Account Level AUM'[Date_Quarter_Acc]),[Edate_Acc],,DESC,Dense)
I have data coming in on all days of a quarter but I need to consider the data with the max(position_date) for each quarter.
New contributor
Sachin Jathavara Sadashiva is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.