Using Slicer or Filter Pane to change the selected date

[12Bowers12]

Hello, everyone,

This question is partially related to my previous question.

In insurance industry, there is one terminology named Earned Premium. For instance, given a policy with $1,000 effective on 01/01/2020 and expired on 12/31/2020, on 06/30/2020, the Earned Premium is $500 since 6 months has passed and therefore half of the premium is earned by insurance company.

In math formula, the Earned Premium = 1000 * (06/30/20 – 01/01/20) / (12/31/20 – 01/01/20).

Similarly, in the following query, I tried to get the Earned Premium.

For the ValueDate, is it possible to use Slicer or Filter Pane on DateDim[DateKey] to change the date on ValueDate? Right now, I use VAR to define the date for ValueDate but it's too static. 

Appreciate your help.

Dennis

PolicyData[PREMIUM] *

DIVIDE ( ValueDate - PolicyData[EFFECTIVE_DATE],

              PolicyData[EXPIRE_DATE] - PolicyData[EFFECTIVE_DATE] )

[AllisonKennedy · Accepted solution]

You should be able to use MAX(DateDim[DateKey]) to get the ValueDate (or the column that has the date in Date format).

[12Bowers12]

Thank you very much, Allison,

It's perfect to combine with Filter Pane.

Before I tried to create a parameter table with Date information. But the report becomes too complex. 

Have a good day.

Dennis

[AllisonKennedy]

You're very welcome. 🙂