Understanding LASTNONBLANK For Use In Power BI

No comments

The LASTNONBLANK function is an interesting DAX formula that you can utilize in a number of different ways inside of Power BI.

It is not a very used DAX formula because of the complexities around how it calculates results.

Most Power BI users, I would presume, don’t even realize that they can utilize the function in a variety of ways inside of Power BI.

The idea in this tutorial is to demystify some of the analysis techniques that can be utilized for this particular function.

Because of its versatility, if you can understand how it can be used in some unique ways, then you can find insights which historically have been very difficult to find and discover within your data and you can find them with quite a simple formula syntax.

If you think about how difficult these sort of insights are to discover using tools like Excel or other visualization tools, you’ll be amazed that it really does make it quite intuitive and effective to find insights that refer to the last of something or on the flip side the first of something if you want to use the FIRSTNONBLANK function.

In this tutorial, I’ll show you a couple of examples of how you can utilize LASTNONBLANK and some of the logic that goes into the function when it is working out the results that you need.

For more DAX formula deep dives, check out the below course at Enterprise DNA Online. If you really want to master DAX then this is the course the certainly check out first.

Mastering DAX Calculations

Sam

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI
FREE COURSE – Ultimate Beginners Guide To DAX
FREE – Power BI Resources
Enterprise DNA Membership
Enterprise DNA Online

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s