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!
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 |
Anonymous
As a calculated column you can use
Column = CALCULATE ( MAX ( Table1[AtrasoBoleto] ), ALLEXCEPT ( Table1, Table1[Recebimento] ) )
6 Replies
Hi Anonymous
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])
