Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to multiple order numbers at a line level?

Hi Power Bi Team, I am trying trying to solve a problem I am running into a power query. I have an order number with more than one line and if only one item is being held for that order I want the rest of the occurrence of other lines of the same order number to be held.

 

Ex: 

Order Num H/O  Hold Reason

96787229HeldMIN_ExpectedDate

 

96787229Opennull

 

I have created a conditional column to calculate this H/O column: 

 

How I want it displayed is if one Order number is held then the rest of the same order number lines should show being held even if they have shipped and not meet the condition of being null in the screenshot.

 

Need Help
  • ryan_mayu's avatar
    ryan_mayu
    4 years ago

    Anonymous 

    i think you can use DAX to create a column

    Column = maxx(FILTER('Table','Table'[order]=EARLIER('Table'[order])&&'Table'[H/O]="Held"),'Table'[H/O])

3 Replies

  • ryan_mayu's avatar
    ryan_mayu
    Icon for Super User rankSuper User
    4 years ago

    Anonymous 

    i think you can use DAX to create a column

    Column = maxx(FILTER('Table','Table'[order]=EARLIER('Table'[order])&&'Table'[H/O]="Held"),'Table'[H/O])

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    ryan_mayu Thank you so much for helping with this issue the dax code worked and appreciate your support!