Forum Discussion
Get value if between dates
Good day, I gave quite a complex problem (I think). I have a large dataset with Leads. Every Lead has a unique LeadId. Every lead is in a phase ranging from 1 to 7, LeadPhaseId. For every Le...
Anonymous , not very clear. See if this can help
I've looked at your .pbix file and it is essentially the solution I was looking for. Only do I have one problem. To make it easier to understand my problem I will use your dataset from now on.
For example: Employee with name N gets hired again on April 14th 2019. A new entry will be created with EmployeeId 20. His start date will be April 14th 2019, and end date will be NULL.
Using this in a graph employee N is counted twice in April 2019. How exactly would I solve that?