Forum Discussion
IF function with Custom Column: Dossier active on specific date( reference date)
Anonymous ,
So according to logic "active = no enddate or enddate after specific date", why the flag is 0 when EndDate is "2-6-2016"? Could you please clarify the logic of this requirement?
Regards,
Jimmy Tao
- Thank you for your reply.
In my example i have written down all possible combinations. We are counting Dossiers for evaluating a possbile growth in dossiers over time. As reference date we are evaluating period 1-7-2016 against 1-7-2019. Which dossiers where active on reference date 1-7-2016? In excel i did it by hand. I put 0 at non active dossiers and 1 at actieve ones. The filter in excel showed 0 and 1 , no blanks. At this point i am certain i did not miss any combination.
If now The calculation is done ln power bi i can match my excel result against it. So for now it is great of you could help me with only the active results.
The dossiers with an end date before 1-7-2016 are then to be blank. The same for dossiers with an end date before 7-2019. no calculation needed for inactieve dossiers.
Answering your question:
The 0 at end date 2-6-2016 was a check mechanisme for The human eye in excel. Thank you for your reply.
In my example i have written down all possible combinations. We are counting Dossiers for evaluating a possbile growth in dossiers over time. As reference date we are evaluating period 1-7-2016 against 1-7-2019. Which dossiers where active on reference date 1-7-2016? In excel i did it by hand. I put 0 at non active dossiers and 1 at actieve ones. The filter in excel showed 0 and 1 , no blanks. At this point i am certain i did not miss any combination.
If now The calculation is done ln power bi i can match my excel result against it. So for now it is great of you could help me with only the active results.
The dossiers with an end date before 1-7-2016 are then to be blank. The same for dossiers with an end date before 7-2019. no calculation needed for inactieve dossiers.
Answering your question:
The 0 at end date 2-6-2016 was a check mechanisme for The human eye in excel.