cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SergioSimionato Frequent Visitor
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.

 

Thank you in advance!

 

Table name: Plan1

 

Structure:

RecebimentoAtrasoBoleto
44444330
44444360
44444300
55555-100
55555-70
55555-10
555555
111111145
111111300
111111400

 

 

How i expected:

RecebimentoAtrasoBoletoMaiorAtraso
44444330360
44444360360
44444300360
55555-1005
55555-705
55555-105
5555555
111111145400
111111300400
111111400400

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
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
Super User

Re: Max value with column condition

Hi @SergioSimionato

 

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])

Highlighted
SergioSimionato Frequent Visitor
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
Super User

Re: Max value with column condition

@SergioSimionato

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

SergioSimionato Frequent Visitor
Frequent Visitor

Re: Max value with column condition

@AlBNo problems Smiley Wink

 

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

 

 Table that i have:

Recebimento

AtrasoBoleto
44444330
44444360
44444300
55555-100
55555-70
55555-10
555555
111111145
111111300
111111400

 

 

What i need:

Recebimento

AtrasoBoletoMaiorAtraso
44444330360
44444360360
44444300360
55555-1005
55555-705
55555-105
5555555
111111145400
111111300400
111111400400

 

 

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

 

Recebimento

AtrasoBoletoMaiorAtrasoRange
44444330360from 355 to 360
44444360360from 355 to 360
44444300360from 355 to 360
55555-1005from 1 to 5
55555-705from 1 to 5
55555-105from 1 to 5
5555555from 1 to 5
111111145400from 395 to 400
111111300400from 395 to 400
111111400400from 395 to 400
Super User
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] )
)
SergioSimionato Frequent Visitor
Frequent Visitor

Re: Max value with column condition

@Zubair_Muhammad

 

Thank you so much! Im looking the answer fo a long time Smiley Very HappySmiley Very HappySmiley Very Happy !!

 

Best regards,