Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

DAX Help

Hi, Can someone help me with dax.   I created 2 measures that take the start date & end Date of the slicer. StartDate = calculate(min(datetable[date]),allselected(datetable[date])) EndDate = cal...
General Comment
Need Help
Show and Tell
parry2k's avatar
parry2k
Super User
6 years ago

Anonymous add this as a mesaure

 

Expired = IF([End Date] > MAX('Card Type'[GracePeriodEndDate]) ,1,0)

 

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi parry2k ,

    Thanks for replying.

     

    I have tried the measure but still didn't got the solution.For the max GracePeriodEndDate getting the solution.

    • parry2k's avatar
      parry2k
      Super User
      6 years ago

      Anonymous sorry I missed the relationship , try this measure

       

      Expired_Measure = 
VAR __m =  MAX('Card Type'[GracePeriodEndDate]) 
RETURN IF ( [End Date] > __m , 1, 0 ) * DIVIDE (__m, __m)

       

      I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        parry2k  I tried this measure but still didn't got the solution.I really appreciate your efforts.Thankyou