• SQLBI

  • Home
  • Training
  • Consulting
  • Articles & Blog
  • Videos
  • Books
  • Tools
  • About
  • Menu
  • Search
  • 0
  • LOGIN
  • Home
  • Training
  • Consulting
  • Articles & Blog
  • Videos
  • Books
  • Tools
  • About
LinkedIn Twitter Facebook Email
Alberto's blog

Visio does not handle Schema? Let’s force it to do!

Sep 6, 2006
SQL Scripts   SQL Server  

Alberto Ferrari

Profile   Blog

Blog Archives
  • 2021 (4)
  • 2020 (1)
  • 2019 (1)
  • 2018 (2)
  • 2012 (7)
  • 2011 (31)
  • 2010 (6)
  • 2009 (7)
  • 2008 (4)
  • 2007 (12)
  • 2006 (6)
Feed RSS
Aug 29-31, 2022
Munich
Register
Distinct values in SSIS
Data Flow Components, constructors and SSIS
Video Course

Mastering Tabular Video Course

Try for free
Jul 16, 2022

Computing sales to specific customers before and after a time period

This article shows how to manipulate the filter context to create a report with the sales made to a specific customer segment, before and after a selected month.  Read more

Aug 7, 2022

Different filter behaviors in SUMMARIZECOLUMNS and CALCULATETABLE

We recently updated SUMMARIZECOLUMNS on DAX Guide by adding an example that clarifies the difference between a filter applied to SUMMARIZECOLUMNS and a filter applied to CALCULATETABLE. Most of the times, you can move a filter from a SUMMARIZECOLUMNS argument…  Read more

Aug 1, 2022

Variables in DAX

Using variables in DAX makes the code easier to read, faster, and easier to debug. In this article, we discuss how and when to use variables, along with why they are so important in any DAX expression.  Read more

Jul 23, 2022

Rolling average with working days in DAX

Rolling averages are a very common calculation used to smooth out charts. This article shows how to compute a rolling average taking into account only the working days.  Read more

13:42
Aug 10, 2022

Context Transition – The Whiteboard #03

Watch now
16:46
Aug 2, 2022

Variables in DAX

Watch now
09:02
Jul 27, 2022

Row Context – The Whiteboard #02

Watch now
Enclose code in comments with <PRE></PRE> to preserve indentation.

Comments

Accept cookies to show comments. Cookies Policy
Allow all cookies

Newsletter

 By subscribing you are agreeing to our Privacy Policy.
174.6K subscribers
Get BI news and original content in your inbox every 2 weeks!
Newsletter archive

What is next

  • Mastering DAX – Aug 29
    , Munich
  • Mastering DAX – Sep 28
    , Brisbane
  • Mastering DAX – Oct 4
    , Melbourne
  • Mastering DAX – Oct 4
    , Amsterdam
  • Mastering DAX – Oct 10
    , Sydney
  • Data Modeling for Power BI – Nov 9
    , Chicago
  • Mastering DAX – Nov 9
    , Chicago
YouTube Twitter LinkedIn Facebook Github RSS Feed
Marco Russo Alberto Ferrari Daniele Perilli
2004-2022 © SQLBI. All rights are reserved.
SQLBI is a trademark of SQLBI Corp.
Loader is a European legal entity.
Privacy Policy & Cookies Terms & Conditions Contact Us
  • SQLBI
  • DAX Guide
  • DAX.do
  • DAX Patterns
  • DAX Formatter
  • Bravo for Power BI
  • OKVIZ