Label Column based on other Column Value

[jcawley]

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 Number	Color	desired output
123	red	blue
123	red	blue
456	red	red
123	blue	blue

Any help would be greatly appreciated!

[Ashish_Mathur · Accepted solution]

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

[jcawley]

Works! Thank you!

[Ashish_Mathur]

You are welcome.