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

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

 

 

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

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.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 6 members 3,712 guests
Please welcome our newest community members: