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 = calculate(max(datetable[date]),allselected(datetable[date]))

 

I want to create a column that shows-that a particular card is expired or not.

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

I am using this formulae but this is giving 0 for all the rows.

 

I have to count Active & Expired cards in a particular Date range.
If i select a date range from 1Jan-2015 to 15Nov-2015 , and a card get expired on 22 June then that card count must come
in Active as well as expired for this date range.

 

General Comment
Need Help
Show and Tell

7 Replies

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