Forum Discussion
Solved
Need help
Hi all,
I need some help on the below Dax
Maxdate =
CALCULATE (
MAX ( S1[Finish] ),
ALLEXCEPT ( s1, S1[Towers] ),
TREATAS ( VALUES ( 'S1'[trade]), S1[Trade] )
)
above dax I have created the column & sample data picture attached below.
my query is trade column 02 BW which finish date max will R17 levels finish date.
but with the above Dax which I created getting the max value of trade 10 LFL finish date max for all.
I want max finish value against trade with last levels
| Trade | Levels | Towers | Finish | Maxdate |
| 07 FL | R17 | B1 (3P+17) | 05-10-21 | 04-12-2021 |
| 05 WP | R17 | B1 (3P+17) | 04-01-21 | 04-12-2021 |
| 06 PB | R17 | B1 (3P+17) | 14-01-21 | 04-12-2021 |
| 03 IP | R17 | B1 (3P+17) | 15-12-20 | 04-12-2021 |
| 04 BR | R17 | B1 (3P+17) | 30-12-20 | 04-12-2021 |
| 09 EL | R17 | B1 (3P+17) | 04-12-21 | 04-12-2021 |
| 12 1P | R17 | B1 (3P+17) | 02-11-21 | 04-12-2021 |
| 08 DO | R17 | B1 (3P+17) | 16-11-21 | 04-12-2021 |
| 02 BW | R17 | B1 (3P+17) | 12-10-20 | 04-12-2021 |
Regards,
Sameer
Please clarify. The 10 LFL you mention is not in the sample data provided. If you want to find the max date for the same Trade as well, did you try this expression?
Maxdate =CALCULATE (MAX ( S1[Finish] ),ALLEXCEPT ( s1, S1[Towers], S1[Trade] ))Regards,Pat
3 Replies
Please clarify. The 10 LFL you mention is not in the sample data provided. If you want to find the max date for the same Trade as well, did you try this expression?
Maxdate =CALCULATE (MAX ( S1[Finish] ),ALLEXCEPT ( s1, S1[Towers], S1[Trade] ))Regards,PatHi,
it is 09 EL
the provided expression does not show value on that column.
Please ignore the earlier mail solution which provided is working.
thanks for the help
