Get Status column based on another column status

[saukulkarni22]

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 then final status will be No PO, if mixed then returned as Partial for those ID. My PO status column is calulated column based on PO ref using power query.

Thanks

[Aburar_123]

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)

[saukulkarni22]

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.

[andhiii079845]

I recommanded to bring this summerize status in a separate table with the ID column

ID	Final status
1	YES
2	Partial
3	NO PO

[saukulkarni22]

Hi,

This could work. Could you provide more details on this.

Thanks