im new to power bi dax. im currently working on getting the earliest date by MO (column MO). Ive tried the dax formula below but it returned the wrong date for one of the MO.
Raw data and expected output
Power BI Output with the current dax function: Column = CALCULATE(MIN('1 (2)'[START DATE ]),FILTER('1 (2)',EARLIER('1 (2)'[MO])))