Forum Discussion

sameergupta60's avatar
sameergupta60
Icon for Helper IV rankHelper 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
Icon for Microsoft Employee rankMicrosoft 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
    Icon for Helper IV rankHelper IV
    5 years ago

    Hi,

     

    it is 09 EL

     

    the provided expression does not show value on that column.

     

     

  • sameergupta60's avatar
    sameergupta60
    Icon for Helper IV rankHelper IV
    5 years ago

    Please ignore the earlier mail solution which provided is working.

     

    thanks for the help