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/ultimate-beginners-guide-to-power-bi
FREE COURSE - Ultimate Beginners Guide To DAX - http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE - 60 Page DAX Reference Guide Download - https://enterprisedna.co/dax-formula-reference-guide-download/
FREE - Power BI Resources - http://enterprisedna.co/power-bi-resources
Enterprise DNA Online - http://www.enterprisedna.co/
Enterprise DNA Membership - https://enterprisedna.co/membership
Enterprise DNA Events - https://enterprisedna.co/enterprise-dna-events-page/

***** Related Links *****
First Purchase Of Customer Insight Using DAX - https://blog.enterprisedna.co/discover-what-was-the-initial-product-a-customer-purchased-using-dax/
Last Purchase Date In Power BI: When Did Your Customers Make Their Last Purchase? - https://blog.enterprisedna.co/when-did-your-customers-make-their-last-purchase-dax-techniques-in-power-bi/
Working With Iterating Functions In DAX - https://blog.enterprisedna.co/working-with-iterating-functions-in-dax/

***** Related Course Modules *****
Time Intelligence Calculations - http://portal.enterprisedna.co/p/time-intelligence-calculations
Unique Analytical Scenarios - http://portal.enterprisedna.co/p/unique-analytical-scenarios
Mastering DAX Calculations - http://portal.enterprisedna.co/p/mastering-dax-calculations

***** Related Support Forum Posts *****
Calculate The Most Recent Value With DAX In Power BI - https://forum.enterprisedna.co/t/calculate-the-most-recent-value-with-dax-in-power-bi/2764
Return Value Based On Most Recent Date - https://forum.enterprisedna.co/t/return-value-based-on-most-recent-date/5475
Date Of Last Sale With Calculated Sale Price - https://forum.enterprisedna.co/t/date-of-last-sale-with-calculated-sale-price/2542
For more calculate recent value support queries to review see here…. - https://forum.enterprisedna.co/search?q=calculate%20recent%20value

Видео Calculate The Last Or Max Value Within A Table Of Data Using DAX In Power BI канала Enterprise DNA