Forum Discussion
RANKING ON DATES AND 2 GROUPS
Hello, I'm new to DAX and I'm trying to index dates chronologically, grouped by customers and contracts. This index must respect the filters. Exemple : I have a dataset with columns CLIENT, ...
I understand the importance of having unique dates but in my case they are not and it is for this reason that I cannot index my dates and that I created this post. This data represents insurance claims. A customer may have a claim on an insurance contract on the same date as another customer or on another contract. Is there a way to circumvent the problem?
foodd
Community Champion
Community ChampionHypothetically, adding your 'Claim number' (and if it is a combination of claim number + indicator + Claimant ID for processing step or change (if necessary) would allow for a unique identifier in the queries). You will need to test and confirm any relationships and filtering within the model.