• Skip to main content
  • Skip to footer

Curbal

Learn how to grow your business with your data and Power BI

  • Data Stories
    • Power BI Stories
    • 1 dataset, 100 matplotlib visualizations
  • Learning Portal
    • Download Center
    • 25 Days Challenge
    • DAX Glossary
    • Power BI
    • Power BI by Topic
    • Python
    • 1 dataset, 100 matplotlib visualizations
  • Courses
    • Power BI Mini Master Class 1: Using a REST API as a data source
    • Power BI Master Class 1: COVID Tracker
    • Introduction to Power BI – FREE Online course
    • M Language + Power Query Course Bundle
    • Power Query Online Training [updated 2022]
    • M Language Online Course: The unofficial and Practical Reference Guide [updated 2025]
    • My Courses
  • Shop
    • Courses
    • Master Classes
    • Template Apps
    • JSON Themes
  • Cart
  • Register/ Log In
    • Become a Member
    • Log In
    • My account
    • My Courses
  • Search
  • Contact
You are here: Home / CM Tooltip Glossary Pro+ / MAX

MAX

posted on April 20, 2018

« Back to Glossary Index

Syntax

MAX(<column>)

MAX(<expression1>, <expression2>)

Tutorial with example

In today’s video we will go through the DAX functions of MAX, MAXX and MAXA.

DAX Fridays! #72: MAX, MAXX, MAXA

Download example file:

Not available

Remarks

When evaluating a single column that contains numeric values, if the column contains no numbers, MAX returns a blank. If you want to evaluate values that are not numbers, use the MAXA function.

When comparing two expressions, blank is treated as 0 when comparing. That is, Max(1, Blank() ) returns 1, and Max( -1, Blank() ) returns 0. If both arguments are blank, MAX returns a blank. If either expression returns a value which is not allowed, MAX returns an error.

Example2: Get previous row in DAX

You have been asking me, how do I calculate previous row in Power BI using DAX so I can get new cases on the corona dataset? , and this is exactly what we are going to do in this video.

Table of contents:

00:50 Append all cases type in one column
03:00 Change the financial times calculation for the new column
04:00 Calculate previous row using dax

Watch the tutorial:

DAX Fridays! #167: Calculate previous row using DAX

Links to the mentioned resources

To get the file:
1. Go to Curbal Download Center > DAX Fridays
2. Get File #167

Was this helpful?
Related Articles:
  • The ultimate dashboard to track your website growth with Google Analytics 4 and Power BI
See Also:
  • ALLEXCEPT
  • MAXA
  • MAXX
  • MINX
  • SUMX
« Back to Index

Reader Interactions

Comments

  1. Wes

    June 14, 2018 at 4:18 pm

    Hope we have the downloadable power bi file available as well : )

    Reply
    • Ruth Pozuelo Martinez

      June 14, 2018 at 4:43 pm

      Hi Wes,
      No file available I am afraid, but you can use any of the other files to try the functions 🙂
      /Ruth

      Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Footer CTA

Join our community of +50,000 professionals

Become a Member

Subscribe to YouTube

About me:

Curbal AB
Badhusgatan 7B
722 15 – Västerås
Sweden

OrgNo: 5569680852 | VAT: SE556968085201

 

Location:

© Copyright 2014-2025 · Curbal AB · All Rights Reserved · Privacy Policy · Terms of Service · Refund Policy · Log In