Search

How to create Dynamic Date Table in Power BI

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

100 views0 comments

Recent Posts

See All

POWER BI DA-100 Personalized Training

If you wish to Learn Power BI for Your Current Job, Entering a New Job or wanted to attend the Exam for certification, you can reach us to know more about this Training. - This training will be comple