Data looks like below, based on NOs. need output as "latest", "No" with reference Part. Tried below but failed.
REV = MAXX(FILTER(Part_Hist,Part_Hist[REV_NUM]>EARLIER(Part_Hist[REV_NUM])),IF(Part_Hist[Part Name]=EARLIER(Part_Hist[Part Name]),"Yes","No"))
REV = MAXX(FILTER(Table1,Table1[Nos]>EARLIER(Table1[Nos])),IF(Table1[Part]=EARLIER(Table1[Part]),"OLD","Latest"))
Go to Solution.
@KL718 Please try this as a New Column
VAR _Max = CALCULATE(MAX(Test260FlagLatest[Nos]),ALLEXCEPT(Test260FlagLatest,Test260FlagLatest[Part]))
Proud to be a Super User!
View solution in original post
Thanks & appreciate.
I was also able to find the solution. Sharing another way which can be used to achieve the output.
I wrote DAX>>
Click here to read more about the December 2021 Updates!
Mark your calendars and join us for our next Power BI Dev Camp!
Learn how to create your own user groups today!