Need help

[sameergupta60]

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 

[mahoneypat · Accepted solution]

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

[sameergupta60]

Please ignore the earlier mail solution which provided is working.

thanks for the help

[sameergupta60]

Hi,

it is 09 EL

the provided expression does not show value on that column.