Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

DAX Help- Logical

Hello World! Firstly Happy Holidays to all the people around the world.  I want to create a new column Initial Mode. I have a dataset drom 2016-2022.  Here I have created a Final Payment M...
  • Mahesh0016's avatar
    Mahesh0016
    3 years ago

    Create Calculated Column :

    Initial Mode = CALCULATE(MAX('Master&Visa'[Prior Mode]),FILTER('Master&Visa','Master&Visa'[Prior Year]<MAX('Master&Visa'[Prior Year])))

    Anonymous Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! 

Mahesh0016's avatar
Mahesh0016
Super User
3 years ago

Create Calculated Column :

Initial Mode = CALCULATE(MAX('Master&Visa'[Prior Mode]),FILTER('Master&Visa','Master&Visa'[Prior Year]<MAX('Master&Visa'[Prior Year])))

Anonymous Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!