Calculate the LY y YoY% of headcount
Hello friends, I am working on an HR Analytics dashboard, in which I want to calculate the following with DAX formulas: 1. Calculate Last Year 2. Calculate the YoY% As data to take into account: In the dashboard I will make filters at the year level I already have a headcount DAX : Headcount= SUM('01_Master Headcount'[Headcount]) and the graph that I want to create is exactly this: The data is assembled as follows (you can download the complete excel file with the data from this link: here) I hope you can help me. I'll be very greatful, Nestor Reyes
