Forum Discussion
Entry with Max Date
Apologies if this is posted somewhere else already. My fact table is as such: there is an entry for each person's interaction with a company. There is a date associated with each interaction and the...
Apologies for the slow reply. While this does help if my output is a row-level table, what I intend to do is create a visualization. For instance, if I wanted to show a breakdown at the race/ethnicity level, the challenge is that the measure above selects the latest date as of the whole dataset. I have tried many variations of this using ALLEXCEPT, for instance, and I need the output to select the latest date as of a date slicer PER PERSON and then identify the relevant race/ethnicity for my visualization.
Hi soupyNoodles please share soome sample data of your inputs and expected output.
Yes, in example above max, last date is for overall data. So we need your details.