Forum Discussion
Creating a Dynamic Slider that Selects Inforce Policies Only that does X with the data.
Thank you for the quick response: let me be clearer with my ask.
In my excel sample, if I selected 2017 Q2, the card should be showing 28.508M from the two 14M in row 2 & 3, since that revenue lies between the effective and expiration date.
From the pbix file, I see that it is dividing the revenue to a revenue per day and only summing up the revenue for the particular Quarter Year selected. It's different than what I had in mind.
Thanks again for trying to help.
Hi,
I just do not understand. Row 2 spans one entire year. So then why should the revenue for one quarter be the same as the revenue for the entire year. I am absolutely confused.
This is the way how it is done for inforce policy for insurance. For inforce line premium, they are looking the total premium for all the policies that still active and talking the sum of their premiums without taking into account what part of each policy premiums lies in the quarter/day/weekly/etc view.