Call Us: 425.702.8175
Follow Us:

Blog - Archive

News, tips, and happenings at Inviso

Category: Power BI

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.