Measure to count transactions between date fields

[JoshK]

Hi

I need to create a new measure which can be used to show a count of business that has been cancelled before it has been taken up but after it as been agreed. I have the following fields which I need to use:

Policy Transaction Count (this will show a count of cancellations)

Accepted Date (this represents the date business was agreed)

Inception Date (this represents the date business was due to start)

I need the measure to show something like:

NTU = CALCULATE([POLICY_TRANSACTION_COUNT] IF IT OCCURS AFTER [ACCEPTED_DATE] AND PRIOR TO [INCEPTION DATE]

I keep finding that only one of the date fields will be displayed in the measure despite the fact they are contained in different tables...

Thanks in advance!

[v-chuncz-msft · Accepted solution]

@JoshK ,

You may take a look at the post below.

https://community.powerbi.com/t5/Desktop/Create-date-Parameter-asat-date-to-get-active-customers/m-p...

[JoshK]

I should also add that I am trying to create a measure which shows:

=CALCULATE([POLICY_TRANSACTION_COUNT], WHEN IT OCCURS WITHIN THE 14 DAYS AFTER [INCEPTION DATE]

AND ALSO

= CALCULATE([POLICY_TRANSACTION_COUNT], WHEN IT OCCURS AFTER 14 DAYS FROM [INCEPTION DATE]

[Greg_Deckler]

Take a look at these two Quick Measures as I think you want something like them.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364
https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365