i got a question, for instance i have the following data:
Empl_Date, Empl, Empl_Position, Sales
03.03.19, Niko, Manager, 100
15.06.19, Niko, Sen.Manager, 150
how can i generate in my column: Empl_Date the new values, like 03.03.19, 04.03.19, 05.03.19
my expected output is:
03.03.19 - 14.06.19, Manager
15.06.19 - Today, Sen. Manager
i could have solved this problem by using of IterNo () - Funktion (when i have 2 Columns; Startdate and Enddate).
But here i have only one column: Empl_Date, i want to show later with master calender, that from 03.03.19 until 14.06.19 i was as Manager, and from 16.06.19 till Today i am doing as Sen.Manager.
Does anybody have any idea how to resolve this issue?
