Forum Discussion
Headcount
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!
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.
2 Replies
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
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.
