Forum Discussion
Get Status column based on another column status
Hi, Wondering anyone can help me here please? I am looking generate final status column based PO status and ID. If all PO status is Yes then final status will be Yes, all PO status is No t...
Hi saukulkarni22 ,
Please use the below calculated column,
Final_State =
var a = CALCULATE(max('Table'[PO Status]),FILTER('Table','Table'[ID]=EARLIER('Table'[ID])))
var b = CALCULATE(MIN('Table'[PO Status]),FILTER('Table','Table'[ID]=EARLIER('Table'[ID])))
return if(a<>b,"Partial",a)
Hi,
Thanks for reply. But forgot to mention I am using direct query and calculate is not supported in direct query for calculated column DAX expression.