Sorry, your browser is not supported
To have the best experience using Skillshare, we recommend that you use one of these supported browsers.
Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
4 Videos (37m)
    • How to add Time Intelligence to a Dimesion


    • PeriodsToDate

    • OpeningPeriod ClosingPeriod


About This Class

In this video series i will discuss Time functions. But the time function will not work until you provide time intelligence to it . I will show how to add Time Intelligence to a Dimesion. Then i will discuss many Time functions used in MDX such as YTD QTD MTD WTD. Then i will also discuss the alternative of (x)TD functions which is PeriodsToDate . In the end i will discuss OpeningPeriod and ClosingPeriod. Thses functions can be useful in case you need to find out opening stock at the start of the month or Closing Stock at the end of the month for an inventory






Reviews (0)

Vikas Munjal

Microsoft Certified Trainer

I am Microsoft Certified Trainer. Having around 10 Years of rich experience.Successfully self-employed, i am a trusted consultant for businesses large and small. Currently working as a Corporate Trainer & Consultant for SQL Server and Microsoft Business Intelligence . Also worked as a SQL Server Developer. Lives in Delhi,India.

My style is to teach in such a way so that student should be able to create images or diagrams of the concept in his/her mind . Because i believe we understan...

See full profile