Forum Discussion
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! T...
Anonymous
As a calculated column you can use
Column = CALCULATE ( MAX ( Table1[AtrasoBoleto] ), ALLEXCEPT ( Table1, Table1[Recebimento] ) )
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 =/
AlB
Community Champion
Community ChampionAnonymous
Sorry, I'm afraid I don't understand what you mean
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 - Zubair_Muhammad
Anonymous
As a calculated column you can use
Column = CALCULATE ( MAX ( Table1[AtrasoBoleto] ), ALLEXCEPT ( Table1, Table1[Recebimento] ) )