Forum Discussion
How to pull a date from subsequent rows.
I have an employee dataset that I am pulling in through an API. I don't have access to manipulate the data prior to pulling it into PBI. It has 1 row for each location that an employee has worked...
Nathaniel_C
Community Champion
Community ChampionHi Anonymous ,
This for a calculated column. Here is my pbix so that you can see how I did this. PBIX
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Nathaniel,
Getting closer. In looking at the results from your data, the End_Date of 4/30/2019 should be on the first line. So basically, the first line would show an effective date of 1/1/2019 thru EndDate of 4/30/2019. The second line would show 5/1/2019 thru 12/31/2999.
Also, I am now getting a circular reference error with the Count Rows variable.