how can i obtain earliest day and lastest date per row/item number using Power Bi?

36 Views Asked by At

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

enter image description here

Power BI Output with the current dax function: Column = CALCULATE(MIN('1 (2)'[START DATE ]),FILTER('1 (2)',EARLIER('1 (2)'[MO])))

enter image description here

0

There are 0 best solutions below