cancel
Showing results for
Did you mean:
Frequent Visitor

## Max value with column condition

Hi there!

Anyone help me? I need bring the max value with column condition, creating the column "MaiorAtraso"...The answer can be through measure or custom column.

Table name: Plan1

Structure:

 Recebimento AtrasoBoleto 44444 330 44444 360 44444 300 55555 -100 55555 -70 55555 -10 55555 5 111111 145 111111 300 111111 400

How i expected:

 Recebimento AtrasoBoleto MaiorAtraso 44444 330 360 44444 360 360 44444 300 360 55555 -100 5 55555 -70 5 55555 -10 5 55555 5 5 111111 145 400 111111 300 400 111111 400 400

1 ACCEPTED SOLUTION

Accepted Solutions
Super User

## Re: Max value with column condition

@SergioSimionato

As a calculated column you can use

```Column =
CALCULATE (
MAX ( Table1[AtrasoBoleto] ),
ALLEXCEPT ( Table1, Table1[Recebimento] )
)
```
6 REPLIES 6
Super User

## Re: Max value with column condition

Try this:

1. Place a matrix visual in your report with Plan1[Recebimento] in rows

2. Place this measure in values of the matrix:

MaxAtraso = MAX(Plan1[AtrasoBoleto])

Frequent Visitor

## Re: Max value with column condition

Hello! @AlB

thank you for the answer, but i can make the column in structure because after i will create conditional column from them, so only visualization at matrix dont  atempt me =/

Super User

## Re: Max value with column condition

@SergioSimionato

Sorry, I'm afraid I don't understand what you mean

Frequent Visitor

## Re: Max value with column condition

@AlBNo problems

From that column "MaiorAtraso" after i will create "ranges" to separate them straight on sctruture, for example:

Table that i have:

 Recebimento AtrasoBoleto 44444 330 44444 360 44444 300 55555 -100 55555 -70 55555 -10 55555 5 111111 145 111111 300 111111 400

What i need:

 Recebimento AtrasoBoleto MaiorAtraso 44444 330 360 44444 360 360 44444 300 360 55555 -100 5 55555 -70 5 55555 -10 5 55555 5 5 111111 145 400 111111 300 400 111111 400 400

After this, i will create conditional column at structure to make others visualizations, not only at matrix:

 Recebimento AtrasoBoleto MaiorAtraso Range 44444 330 360 from 355 to 360 44444 360 360 from 355 to 360 44444 300 360 from 355 to 360 55555 -100 5 from 1 to 5 55555 -70 5 from 1 to 5 55555 -10 5 from 1 to 5 55555 5 5 from 1 to 5 111111 145 400 from 395 to 400 111111 300 400 from 395 to 400 111111 400 400 from 395 to 400
Super User

## Re: Max value with column condition

@SergioSimionato

As a calculated column you can use

```Column =
CALCULATE (
MAX ( Table1[AtrasoBoleto] ),
ALLEXCEPT ( Table1, Table1[Recebimento] )
)
```
Highlighted
Frequent Visitor

## Re: Max value with column condition

Thank you so much! Im looking the answer fo a long time !!

Best regards,

Announcements

#### Community News & Announcements

Get your latest community news and announcements.

#### Power Platform Summit North America

Register by September 5 to save \$200

#### Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 6 members 3,712 guests
Recent signins: