Forum Discussion

sameergupta60's avatar
sameergupta60
Helper IV
5 years ago
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 cr...
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    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
mahoneypat's avatar
mahoneypat
Microsoft Employee
5 years ago

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's avatar
sameergupta60
Helper IV
5 years ago

Hi,

 

it is 09 EL

 

the provided expression does not show value on that column.