Skip to Content

Loading Events

« All Events

  • This event has passed.

Modelling Edition: Time-intelligence DAX functions in Power BI Desktop

June 15 @ 12:00 pm - 1:30 pm EST



***This is a FREE event but you must be a registered with MPUG to attend. Please register for a free 1-week trial to MPUG if you have never been a member***


Microsoft Corporation (I) Pvt. Ltd.
#471 2nd floor, Prestige Polygon
Anna Salai, Rathna Nagar Teynampet
Chennai, Tamilnadu
India 600018


All attendees should bring any one identity proof without fail as mentioned below:
Pan Card, Driving License, Passport, Aadhaar Card or Company ID Card


Mandatory Requirements:
1. Laptop should have latest version of Power BI Desktop (download from
2. USB port should be enabled to copy practice files.
3. Bring your WIFI dongle or hotspot device (optional)
4. Bring any one identity proof for Microsoft security registration purposes.


+ Data Scientists
+ Business Intelligence Analysts
+ Excel Users
+ or anyone working with vast amount of data …


Learning Objectives:
At the end of this session, you can manipulate data using time periods with the support time-intelligence DAX functions in Power BI desktop. You will achieve this objective through the following topics:
+ Date table
+ Mark as Date table setting
+ Relationship with Date table
+ Functions returning a scalar value
+ Functions returning a table


Learning Outcomes
Through time intelligence functions you have a consistent way to build and compare calculations over time periods


11:45 – 11:59: Registration and Networking
12:00 – 13:30: Presentation: Modelling Edition: Time-intelligence DAX functions in Power BI Desktop
by E. Prasanna and B Sai Prasad
13:31 – 13:35: Upcoming events, feedback and closing


PDU: 1.5 PDUs in Technical category for PgMP, PMP, PMI-SP credential holders


Our Sponsors: Special Thanks to “Microsoft, Chennai” for the venue and food arrangements.


Speaker Bio:






Prasanna, MTech, Technical consultant Enterprise Project Management Solutions

He has 5+ years of experience in Project management in Engineering and Construction Industry and has been named of the company’s star presales technical consultant of the year award. He has handled many C-level Presentations for oil and Gas, Petrochemical and Architectural Engineering and Construction domain on Project management, Project Risk Management, Project process management.

He has implemented Enterprise Project and Process management solutions and has been constantly supporting to deliver best to various organization. He has delivered Business Intelligence reports leveraging an organization’s reporting standards.

He is Indian Green Building Council Accredited professional and He has experience in consultation for Certification of Green Building for AEC sector.


B Sai Prasad, PMP®, PMI-SP®, MVP Project, Senior Manager – Learning & Development, has been with service provider Cognizant Technology Solutions India Pvt. Ltd since 2001 where he was named winner of the company’s Global Trainer of the Year award. He has spent 13,000-plus hours in mentoring, coaching, training 9000-plus practitioners on project management topics ranging from project management concepts, project risk management, project scheduling, Microsoft Office Project® to software estimation techniques.

He is a Champion of Project Management from PMI India and also Associate Champion Advisory Committee, PMI India. He is awarded the Champion of the Quarter (Q4 – 2012) and Delivery Excellence Award (2011-2012, 2012-2013) from PMI India. He’s also the editor of the project management book, Forecast Scheduling with Project 2010. He is a Microsoft Certified Technology Specialist (MCTS) in Project 2010. He is the President of the MPUG India Chennai chapter to promote and help practitioners on how to effectively use Microsoft Office Project.

Please enter your email to continue viewing