We write articles and white papers on Microsoft Business Intelligence technologies on a regular basis, with a focus on DAX and Data Modeling. The list below showcases all our content sorted chronologically - you can filter through the content by post type, topic, and author.
    Page 22 of 213 articles
article –

Separate date and time in PowerPivot (and BISM tabular)

In PowerPivot you can import data from several sources and it is often the case that you import a DateTime column from a database. From an analytical point of view, you usually make analysis over dates (day/month/year/quarter/week) and over time…  Read more

article –

DateTool dimension: an alternative Time Intelligence implementation

Year-To-Date and Difference-Over-Previos-Year (or Year-Over-Year Growth) are among the most required features of any user. Some OLAP client (like ProClarity) offers features that try to solve this problem client-side, but I don’t like this approach given that you might have…  Read more