Active Policy ID

Question

Hi&nbsp;I wanted to create Count of&nbsp; Active policy numbers using daxI have a calendar table&nbsp; &amp; another table i am having Start date &amp; End Date along with Policy Number refer below image&nbsp;In my report view i have year slicer and Month Selection&nbsp;It is created based on the above start date and End date&nbsp; so it contains values from 2022 to 2023Scenario : If i select 2022 from year slicer and&nbsp; January from Month slicer&nbsp;BASE ON THE ABOVE IMAGE 3 POLICY ARE ACTIVE&nbsp;&nbsp;The policy ID 123, 342 is straight forward but policy 125 also should be Active that is the requirmentBecause&nbsp; policy number 125 also coming under on this range itself (2023)How can we achive this logic in dax ,Appreciate help on this&nbsp;&nbsp;

vicky_ · Answer

Try a measure like this:Active = 
var dateRange = CALCULATE(MIN('Calendar'[Date]), ALLSELECTED('Calendar'[Date]))
return IF(SELECTEDVALUE('Table'[Start]) &lt;= dateRange &amp;&amp; SELECTEDVALUE('Table'[End]) &gt;= dateRange, "Active", "Inactive")&nbsp;

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
There are some things I don't understand too much. Why choose 2022 and January, but Policy ID 342 is active.&nbsp;
The date range for ID 342 is 2023-1-1 to 2023-12-31. January 2022 is not in this range.
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Best Regards,
Stephen Tao
&nbsp;
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;

Forum Discussion

Active Policy ID

2 Replies

Related content

update policy and streaming policy conflict

Restricted View Policy Bug

KQL update policy

Creating ICMs via Activator

Activity Statistics