Calculate The Last Or Max Value Within A Table Of Data Using DAX In Power BI

In this tutorial, we review how you can work out the last value from a particular dimension in a table in Power BI.

This is quite a unique insight but a relevant one from many pieces of analysis that you might require in Power BI.

We work through examples of the MAXX and FILTER functions. These are two important functions in the DAX language that can be used in many situations to extract very interesting insights from your data.

Good luck.

Sam

**** Video Details ****
2:27 - using calculated columns
6:13 - using a measure

**** Learning Power BI? ****
FREE COURSE - Ultimate Beginners Guide To Power BI - http://portal.enterprisedna.co/p/ulti...
FREE COURSE - Ultimate Beginners Guide To DAX - http://portal.enterprisedna.co/p/ulti...
FREE - 60 Page DAX Reference Guide Download - https://enterprisedna.co/dax-formula-...
FREE - Power BI Resources - http://enterprisedna.co/power-bi-reso...
Enterprise DNA Online - http://www.enterprisedna.co/
Enterprise DNA Membership - https://enterprisedna.co/membership
Enterprise DNA Events - https://enterprisedna.co/enterprise-d...

**** Related Links ****
First Purchase Of Customer Insight Using DAX - https://blog.enterprisedna.co/discove...
Last Purchase Date In Power BI: When Did Your Customers Make Their Last Purchase? - https://blog.enterprisedna.co/when-di...
Working With Iterating Functions In DAX - https://blog.enterprisedna.co/working...

**** Related Course Modules ****
Time Intelligence Calculations - http://portal.enterprisedna.co/p/time...
Unique Analytical Scenarios - http://portal.enterprisedna.co/p/uniq...
Mastering DAX Calculations - http://portal.enterprisedna.co/p/mast...

**** Related Support Forum Posts ****
Calculate The Most Recent Value With DAX In Power BI - https://forum.enterprisedna.co/t/calc...
Return Value Based On Most Recent Date - https://forum.enterprisedna.co/t/retu...
Date Of Last Sale With Calculated Sale Price - https://forum.enterprisedna.co/t/date...
For more calculate recent value support queries to review see here…. - https://forum.enterprisedna.co/search...