Forum Discussion
Solved
Creating a latest occurrence column
Hello fellow PBI'ers, I am hoping to create a calculated column which identifies the latest occurrence with each account based on a few criterias. The result is as per the "Desired_Result" column...
Try this
_Latest Result Column= Var Acc = 'Latest Occurence'[AccountName] Var Pro = 'Latest Occurence'[Product] Var dt = CALCULATE(MAX('Latest Occurence'[EndDate ]),FILTER('Latest Occurence','Latest Occurence'[AccountName]=Acc && 'Latest Occurence'[Product]=Pro && 'Latest Occurence'[Family]="Maintenance")) RETURN IF(dt='Latest Occurence'[EndDate ] && 'Latest Occurence'[Family]="Maintenance","Latest","")
Amazing, thank you both Jihwan_Kim & FarhanAhmed ! Both measures work as it should and has saved my hair. True life saver 🙂