Forum Discussion
Changing the Granularity Level | There are Some Caveats
Hi Everyone: I am stuck with this conundrum. Could someone help, please? The figure below is a snapshot of our Employee Lifecycle table, which contains information pertaining to every event in...
Hi Anonymous
Many thanks for your reply.
You can access the sample file here: https://drive.google.com/drive/folders/1OXkbnDya2FUn36WZWmL4uaznfv-WhEI1?usp=sharing
On the 2nd tab of the file, columns F, G, and H have been manually done by me. I need to create those columns using PQ, then fill down all the dates between "Eff_Start_Date" and "Eff_End_Date."
I have used fake employee and client names to protect confidentiality.
Many thanks for responding. Hope you'll be able to help.
Regards,
Aji