Headcount

[Anonymous]

Hello

I am new to Power BI and I'm struggling to write a measure which pulls out the HC for the last period of each previous FY to compare against the current FY month.

Can anyone advise please? Sorry if this is a simple query 😞

Thanks!

[Anonymous · Accepted solution]

Hi @Anonymous ,

You may create fiscal columns in your calendar table as explained in the below blog post and leverage those columns in your calculations.

Create a Date Dimension in Power BI in 4 Steps – Step 2: Fiscal Columns - RADACAD

If you want to handle this with DAX, refer to the following post

Creating Financial Calendar - Decoding Date and Ca... - Microsoft Power BI Community

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[BA_Pete]

Hi @Anonymous ,

You'll need to provide an example of your data and its structure.

This isn't just a generic query/calculation, it will need to be tailored to your data.

Pete