Tag: Calculated Column DAX

Calculated Table And Column In Tabular Editor 3

This tutorial will discuss how to create a calculated table and column in the Tabular Editor. You’ll learn how to pull out and summarize tables and columns using DAX functions. You’ll also understand why Tabular Editor is better at creating calculated tables and columns than Power BI Desktop. Creating A Calculated Column To create a

Continue reading

Calculated Columns Power BI: Tips & Best Practices

Best Practices When Using Calculated Columns In Power BI

This tutorial will discuss the best practices in using calculated columns in Power BI. We’ll also be going through the DAX formulas used to create them. In previous discussions, we’ve gone through how to write different measures in Power BI, but another technique we can use is to create calculated columns. Other than measures, using

Continue reading

Show Results Up To Current Date Or A Specific Date In Power BI

dax current date power bi post image

In this tutorial, I’ll show you a very specific technique where you can show data or filter up to the current date (today) or any specific date in your Power BI reports. I’ve seen this asked a few times, especially on the Enterprise DNA Support Forum. I’ve personally used this technique many times, so I

Continue reading

Comparing Calculated Columns And Measures In Power BI

Measures vs Calculated Columns In Power BI

In this tutorial, I will cover the two places where you can write your DAX formulas. These two places are the calculated columns and measures. You may watch the full video of this tutorial at the bottom of this blog. I will go over each one at a time and I’ll start with calculated columns.

Continue reading