Hi I’m having a lot of trouble with something I would have thought is quite easy.
Essentially I’m trying to get a distinct count of document IDs that were in my fact table on the previous extract date (‘Upload Date’) relative to the date in the current row context.
What I think makes this slightly trickier is that there is no uniform frequency of the data extracts i.e. one on the 2 Oct, next on the 12 Oct and next after that on the 26 October etc. Also, the extract date is not the date field actively linked to my date table (although I do have inactive relationship set up for it).
In the image attached I’m trying to create a measure that gives me the total ID count on the previous ‘UploadDate’ i.e. next to the 12 Oct it should show the number of exceptions from the 2nd October (27563)
Thanks in advance for any support.