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
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

    • parry2k's avatar
      parry2k
      Super User
      6 years ago

      Anonymous I have no idea why it is not working, share the pbix file, remove sensitive info before sharing.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        parry2k  Yeah Sure