Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

fill column value based on value in another column

I am having following table, I want the 'Value' column to be filled for VCF and VCT based on Value of VCL where SO,BN and MV is same for VCL,VCF and VCT.

NameCol1SOBNMNValue
VCL544911315906C721578EMS6108005ENA1
VCF204811315906C721578EMS6108005EN 
VCT274511315906C721578EMS6108005EN 
VCF637411327179C721578GMS9666005EN 
VCT204811327179C721578GMS9666005EN 
VCL176511327179C721578GMS9666005ENA2

 The output table should be 

NameCol1SOBNMNValue
VCL544911315906C721578EMS6108005ENA1
VCF204811315906C721578EMS6108005ENA1
VCT274511315906C721578EMS6108005ENA1
VCF637411327179C721578GMS9666005ENA2
VCT204811327179C721578GMS9666005ENA2
VCL176511327179C721578GMS9666005ENA2

 

experts, please help me on this. amitchandak, parry2k 

Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    5 years ago

    Hi, Anonymous 

    Your column type is "text", I would suggest you to use [Value]=" "   to replace isblank([Value]

    So please change your formula of calculated column as below:

     

    Value2 = if([Value]="",MAXX(FILTER('Table','Table'[MN]=EARLIER('Table'[MN])),[Value]),[Value])

     

    Best Regards,
    Community Support Team _ Eason
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

4 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Anonymous , Try a new column like

     

    if(isblank([Value]),maxx(filter([MN] =earlier([MN]) && not(isblank([Value]))),[Value]),[Value])

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thanks for responding. It's showing error msg as- Too few arguments were passed to the FILTER function. The minimum argument count for the function is 2.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      I tried this insted- 

      if(isblank([Value]),MAXX(FILTER('Table','Table'[MN]=EARLIER('Table'[MN])),[Value]),[Value]) 
       
      but it's returning a new columns with same data in Value column.
      • v-easonf-msft's avatar
        v-easonf-msft
        Icon for Community Support rankCommunity Support
        5 years ago

        Hi, Anonymous 

        Your column type is "text", I would suggest you to use [Value]=" "   to replace isblank([Value]

        So please change your formula of calculated column as below:

         

        Value2 = if([Value]="",MAXX(FILTER('Table','Table'[MN]=EARLIER('Table'[MN])),[Value]),[Value])

         

        Best Regards,
        Community Support Team _ Eason
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.