DAX to Return Column Value when there is no primary key but will only be based on Dates
Hi, I've been spending weeks trying to figure this out, hoping you could help me.
In my PBI, I have 2 tables - one is the class_tbl(dojo table) and the roster. I am trying to get the "wave" of a user if the date in roster is between the training start and end dates. And for the remaining dates in the roster will be the wave where the user attended the last training.
I used LASTNONBLANK but it only returned the first 2 waves.
There are multiple IDs that have this case, but this ID is one example.