Marco Russo's blog posts of 2018

5 blog posts
blog post –

International year_end_date for YTD functions in DAX

If you used the DATESYTD and TOTALYTD functions in DAX, you might have noticed that the optional parameter year_end_date is a string defining the last day of the year. The default is December 31, so this parameter is used only…  Read more

blog post –

Two weeks, two countries, two conferences, one family

In the last week, I have been speaking at two different events in a few days: SQLBits 2018 in London, UK and SQL Konferenz 2018 in Darmstadt, Germany. These two events created for SQL Server professional are now “polluted” by…  Read more

blog post –

The new Data Modeling for Power BI course

If you import more than one table into Power BI or Power Pivot, you have a data model. When you have more than one table, you usually have relationships between tables. When you analyze data, you often have many choices…  Read more

blog post –

Power Pivot Utilities 1.09

Bertrand d’Arbonneau added a new feature in the last version (v 1.09) of Power Pivot Utilities, which allows the visualization of Dependents and Precedents measures in the measure list created by the List Measures tool. How to use the new…  Read more

blog post –

Why I attend conferences and why I speak at conferences

I’ve recently been asked to talk about my experience as a speaker at technical conferences. I wasn’t sure what to say, until I realized that it makes more sense to start with explaining the reasons why one should attend a…  Read more