DAX Help

[Anonymous]

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.

[parry2k]

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

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]

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

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

[parry2k]

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

[Anonymous]

Hi @parry2k ,

I have emailed you the details pls have a look at it.

Thanks

[Anonymous]

@parry2k  Yeah Sure