Forum Discussion

jcawley's avatar
jcawley
Helper III
4 years ago
Solved

Label Column based on other Column Value

Good afternoon Power BI Community,

 

I’m having a problem with a column. Let’s say I have a table with two columns. One that lists Invoice Number, and another that lists Color. I want to create a column that labels them all one value if a certain value is present.

In this case, if "blue" is ever mentioned in assocaition with an Invoice Number, I want a column that repeats "blue" for all lines associated with the invoice number.

EX:

 

Invoice NumberColordesired output
123redblue
123redblue
456redred
123blueblue

 

Any help would be greatly appreciated!

Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    This calculated column formula works

    =if(CALCULATE(COUNTROWS(Data),FILTER(Data,Data[Invoice Number]=EARLIER(Data[Invoice Number])&&Data[Color]="Blue"))>0,"Blue"
,Data[Color])

    Hope this helps

3 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    4 years ago

    Hi,

    This calculated column formula works

    =if(CALCULATE(COUNTROWS(Data),FILTER(Data,Data[Invoice Number]=EARLIER(Data[Invoice Number])&&Data[Color]="Blue"))>0,"Blue"
,Data[Color])

    Hope this helps