Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Transfer calculated column into power query

Hello, is it possible to bring this formula for a Calculated column directly into Power Query. thanks in advance  
Need Help
  • BA_Pete's avatar
    BA_Pete
    3 years ago

    Hi Anonymous ,

     

    I think it would be something like this in a new custom column:

    if List.Contains(List.Buffer(previousStepName[Komponente]), [TopMaterial])
then null else "TopTopMat"

     

    Pete

BA_Pete's avatar
BA_Pete
Super User
3 years ago

Hi Anonymous ,

 

I think it would be something like this in a new custom column:

if List.Contains(List.Buffer(previousStepName[Komponente]), [TopMaterial])
then null else "TopTopMat"

 

Pete