Call Us: 425.702.8175
Follow Us:

Blog - Archive

News, tips, and happenings at Inviso

Category: DAX

DAX Made Easy - Rolling Averages

  • by Andy Parker
  • August 28, 2017

After spending significant time writing the perfect DAX expression to calculate rolling averages in Power BI, I was pleasantly surprised by the April Power BI Desktop release that included a slew of new pre-built "Quick Measures" that take much of the pain away from writing complicated DAX measures.

Read more

Auto-generating Date Tables in Power BI Desktop

  • by Joe Gravelyn
  • June 20, 2017

It’s common practice for data-centric companies to have a standard date table to use for reporting purposes with all kinds of useful fields to measure performance over time.

But what if you - or other users of the report - don’t have access to that date table? Power BI has a built in function that allows you to generate a date table on the fly. Combine that function with a couple of DAX formulas and parameters in the Query Editor window, and you get a reusable template you can use for almost all of your time intelligence needs.

Read more

Subscribe to our newsletter

© 2017 Inviso Corporation. All rights reserved.