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 plea...
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.
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