Forum Discussion

AlanP514's avatar
AlanP514
Post Patron
3 years ago

Active Policy Number

Hi 

I wanted to create Count of  Active policy numbers using dax
I have a calendar table  & another table i am having Start date & End Date along with Policy Number refer below image


In my report view i have year slicer and Month Selection 
It is created based on the above start date and End date  so it contains values from 2022 to 2023

Scenario : If i select 2022 from year slicer and  January from Month slicer 
BASE ON THE ABOVE IMAGE 3 POLICY ARE ACTIVE 

The policy ID 123, 342 iis straight forward but policy 125 also should be Active that is the requirment
Because  policy number 125 also coming under on this range itself (2023)

How can we achive this logic in dax ,
Appreciate help on this 



Need Help
Show and Tell
Tips and Tricks

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi  AlanP514 ,

     

    Sorry, it's not clear what you mean, because when your slicer Year=2022 and month=January, the [Policy ID]=342 and [Policy ID]=125 examples do not include the date selected by the slicer.

    If you can provide more detailed DAX logic, we can better help you.

     

     

    Best Regards,

    Liu Yang

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