cancel
Showing results for
Did you mean:
Regular Visitor

## Max Value of two variables

Hello

Please see table below - I am trying to calculate the 'Max of both Colours Column'.

I am trying to calculate the Max In Stock of the two colours from the Shop provided, in a column. For example, Shop A has Black_A and Black_B, and i would like to calculate the max In Stock value of them both, and create a column of that, in this case 1. At the same time, i would also like to find out the MAX in stock value of Silver_A and Silver B. I would like to do this for multiple shops

We havent got anywhere with this, but would appreciate your help!

Thanks

 Shop Colour In Stock? Max of both colours A Black_A 1 1 A Black_B 1 1 A Silver_A 1 1 A Silver_B 0 1 B Black_A 0 0 B Black_B 0 0 B Silver_A 0 1 B Silver_B 1 1 C Black_A 1 1 C Black_B 1 1 C Silver_A 0 0 C Silver_B 0 0
5 REPLIES 5
Super User IV

## Re: Max Value of two variables

When you say max of both colors, do you mean color is BLACK or SILVER?

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Regular Visitor

## Re: Max Value of two variables

Hi @parry2k

i would like to find the max of Black_A or Black_B and also the max of Silver_A or Silver_B

thanks

Super User IV

## Re: Max Value of two variables

understood but what groups black_a and Black_b in your data model.

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Regular Visitor

## Re: Max Value of two variables

@parry2k

This is the difficulty i have, nothing groups them - i need to pick them out of the column and find the max in stock value between them.

Thanks again

Member

## Re: Max Value of two variables

Assuming your colours always have schema colour_x and only the part on the left of "_" counts, you can use following calculated column:

```Max of colours =

MAXX(
FILTER (
Tabelle1,
Tabelle1[Shop] = EARLIER ( Tabelle1[Shop] ) && LEFT(Tabelle1[Colour], FIND("_", Tabelle1[Colour])) = LEFT(EARLIER(Tabelle1[Colour]), FIND("_", EARLIER(Tabelle1[Colour])))

), Tabelle1[In Stock?])```

Announcements

#### Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

#### Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

#### Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.