Forum Discussion

shalabh's avatar
shalabh
Helper I
2 years ago
Solved

Help with active lic calculation

Hi,   I am trying to find the # of active lic every quarter. My raw data has  1. Close date - this is the date on which the order was close 2. Lic start date - date when lic starts(can be same a...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi shalabh ,

     

    I think it's achievable, but you need to sort out your effective conditions. For what you said above, I obtain results that are not consistent with your expectations and can elaborate on what serves as the primary validity condition, as well as other secondary validity conditions.

     

    Measure = var _Close = MONTH(MAX('Table'[Close]))
var _Start = MONTH(MAX('Table'[Start]))
var _End=MONTH(MAX('Table'[End]))
var _Select=SELECTEDVALUE('Table 2'[Date].[MonthNo])
RETURN IF(_Close<=_Select&&_Start=_Select&&_End>_Select,1,0)

     

    An attachment for your reference. Hope it helps!

     

    Best regards,
    Community Support Team_ Scott Chang

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi shalabh ,

 

I think it's achievable, but you need to sort out your effective conditions. For what you said above, I obtain results that are not consistent with your expectations and can elaborate on what serves as the primary validity condition, as well as other secondary validity conditions.

 

Measure = var _Close = MONTH(MAX('Table'[Close]))
var _Start = MONTH(MAX('Table'[Start]))
var _End=MONTH(MAX('Table'[End]))
var _Select=SELECTEDVALUE('Table 2'[Date].[MonthNo])
RETURN IF(_Close<=_Select&&_Start=_Select&&_End>_Select,1,0)

 

An attachment for your reference. Hope it helps!

 

Best regards,
Community Support Team_ Scott Chang

 

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.