YTD Flags in Power Query

YTD Flags in Power Query What are YTD Flags in Power Query? Dates tables are an integral part of creating data models in Power BI. Dates tables allow you to normalize a variety of different date fields and perform calculations … Read More

Import v Direct Query: Here’s What You Need to Know

Import v Direct Query: Here’s What You Need to Know When connecting to data in Power BI, you need to choose whether you want to use Import or Direct Query mode for connecting to your data. Using the Import method, … Read More

Page Navigation in Power BI

Page Navigation in Power BI Enabling users to sensibly navigate your Power BI reports is crucial for providing users with a great user experience. Luckily, there are a variety of ways to do this in Power BI.  In this blog … Read More

Optimizing Power BI Reports

Optimizing Power BI Reports Why is it Important to Optimize Power BI Reports? When developing reports in Power BI Desktop (or any software for that matter), good performance in terms of load time is important for gaining trust with stakeholders … Read More

Report Page Tooltips in Power BI

Report Page Tooltips in Power BI Fitting all the details you want displayed about a certain data point in your report can be a struggle. Often, it’s getting to that next level of your data’s granularity that is the tricky … Read More

Creating a Measures Table in Power BI

Creating a Measures Table in Power BI Creating a measures table in your Power BI data model is one of the most common questions we get from folks wondering how they can better organize the measures they create.  When navigating … Read More

3 Fun Tips for Containers in Tableau

3 Fun Tips for Containers in Tableau! During an internal data visualization learning session at Tessellation I presented on a couple of fun ways that I use containers in my Tableau dashboards. Although many of the folks on the call … Read More

The CALCULATE() Function in Power BI

The CALCULATE() Function in Power BI For readers familiar with Power BI, you already know that the CALCULATE function is one of the most important DAX functions in the platform. This function is commonly used, extremely useful, and opens up … Read More

How to Create YTD Calculations in Power BI​

How to Create YTD Calculations in Power BI Recently, Tessellation put out a blog covering how to create Year to Date (YTD) calculations in Tableau, which you can find here. Regardless of what industry or company you work in, comparing … Read More

How to Create YTD Calculations in Tableau

How to Create YTD Calculations in Tableau One of the most commonly requested items in Tableau dashboarding is to show your metrics as Year to Date (YTD), Prior Year to Date (PYTD), and Year over Year change (YoY). Although seemingly … Read More