Time Intelligence is probably the most interesting feature of any analytical solution. Computing
YearToDate, MonthToDate, SamePeriodLastYear, is quite easy in DAX but, as soon as the
customer requests for time intelligence comparing data from different tables, or to manage
nonstandard calendars, the DAX formulas start to be harder to write.
In this session, we are going to show how to compute classical time intelligence with the builtin
Power BI tools and DAX functions. Then, we will show some more complex time intelligence
formulas, which require thinking out of the box, using advanced data modeling and querying
techniques to produce interesting and useful formulas.

About Marco Russo
His main activities are related to data warehouse relational and multidimensional design, but
he is also involved in the complete development lifecycle of a BI solution. He has particular
competence and experience in sectors like financial services (including complex OLAP
designs in the banking area), manufacturing, gambling, and commercial distribution.
Marco is also an author and, in addition to his BIrelated publications, he has authored
books about .NET programming. He is also a speaker at international conferences such as
TechEd, PASS Summit, SQLRally, and SQLBits.
SUBSCRIBE!
   / @globalpowerbiusergroup  

LET'S CONNECT!

http://community.powerbi.com/t5/Globa...
  / globepug  
  / powerbi  
  / 6631454