NEW ARTICLE

Compare equivalent periods in DAX

If you do not have a full month with data, comparisons such as year-over-year (YOY) might require particular filters in order to do a like for like comparison in DAX. This article describes how to write DAX expressions comparing equivalent periods, keeping corresponding number of days in the comparison.

» READ MORE



 


UPDATED TOOL

Introducing VertiPaq Analyzer v1.7

If you work with Power Pivot, Power BI, or Analysis Services Tabular, you probably already know VertiPaq Analyzer. If you never used it, with the new release 1.7 you have another couple of very good reason to try it.

VertiPaq Analyzer

» SEE IT IN ACTION (VIDEO)
» READ BLOG POST

» FREE DOWNLOAD


 

COURSE CALENDAR 2017

United States, Australia and Europe

Join us learning DAX and SSAS Tabular over the world.
Also in United States, finally!

United States
 SEATTLE, WA
Mar 27-29 – Mastering DAX Workshop
Mar 30-31 – Optimizing DAX Workshop

HOUSTON, TX
Apr 3-4 – SSAS Tabular Workshop
Apr 5-7 – Mastering DAX Workshop

Upcoming announcements for delivery in United States within June 2017: New York, Los Angeles, Minneapolis, Chicago.


Australia
 SYDNEY
Feb 20-21 – SSAS Tabular Workshop
Feb 22-24 – Mastering DAX Workshop

MELBOURNE
Feb 27 - Mar 1 – SSAS Tabular Workshop
Mar 2-3 – Optimizing DAX Workshop


Europe
 Learn DAX and SSAS in the following cities: Amsterdam, Copenhagen, Helsinki, London, Paris, Stockholm, Vienna.