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