Forum Discussion

saukulkarni22's avatar
saukulkarni22
Frequent Visitor
3 years ago

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 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

Need Help

4 Replies

  • andhiii079845's avatar
    andhiii079845
    Solution Sage
    3 years ago

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

    IDFinal status
    1YES
    2Partial
    3NO PO
      
    • saukulkarni22's avatar
      saukulkarni22
      Frequent Visitor
      3 years ago

      Hi,

       

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

       

      Thanks

  • Aburar_123's avatar
    Aburar_123
    Solution Supplier
    3 years ago

    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's avatar
      saukulkarni22
      Frequent Visitor
      3 years ago

      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.