Julian Chen

6 Flips | 1 Magazine | @JulianChen5rp5 | Keep up with Julian Chen on Flipboard, a place to see the stories, photos, and updates that matter to you. Flipboard creates a personalized magazine full of everything, from world news to life’s great moments. Download Flipboard for free and search for “Julian Chen”

Dynamic Power Query

The following post was written as the reply to a great question Dane asked in the Comments section of the Power Query’s Unpivot Function post I wrote …

Using Aggregate to Count Visible Rows

In this post I’m going to show one of my favourite financial modeling tricks: how to use Aggregate to Count Visible Rows.BackgroundOften, when I’m …

Power Pivot and Complex DAX Expressions

Using "IN" Operator in DAX

If you are a SQL guy I bet you’ve used “IN” operator zillions of times. You might also looked for the same functionality in DAX and I’m sure you’ve …

When to Create a Lookup Table in Power Pivot

<i>Level: Beginners</i><p>Today I explain when it is important to create a lookup table and when it is fine to use native columns in a data table. I have rated …

Databases