A Common Question by many Power Beginners that how to have a Fiscal Quarter and Fiscal Year Fields on the basis of Fiscal Calendar in Date Dimension Table. I see many posts asking this question in many forums.
In the above video I have explained how to create a simple logic to understand any fiscal Year ( viz., Apr to March, July to Jun and so on). This video should be able to help you to understand complete Calendar Table and also how to sort different columns (conditional Columns) based on other columns (Sort by Column option for Data Modelling).