Filter to show whichs clients didnt renew their contract after 2 month

[ItSupportElm]

Hello,

I will try to be the most clear possible to explain the situation and sorry for my english is not totally operational.

Here the context : i have a database, where there is my table Clients and the date of the end of their contract, i want to use power BI to show which clients didnt renew their contract after 2 month. Is it possible to do that ? if yes can you tell me how do that please.

Thanks for the futur answer.

Great Day

[tangutoori]

provide sample data and proivde expected outpur so that we can look into it.

[ItSupportElm]

---

@tangutoori wrote:

provide sample data and proivde expected outpur so that we can look into it.

---

I have the date of the beggining contract then the date of the end and also the due date but they are not in the same table but their are in "relation".

for example : 

 

Due Date (years and month) : 

[v-frfei-msft]

Hi @ItSupportElm ,

To use RELATED function to create calculated column and compare dates between two columns should work.

[ItSupportElm · Accepted solution]

Hi @v-frfei-msft  and @tangutoori 

i think i didnt explain the situation correctly. 

So i have a Table Clients and Contract and also the date of the end of the contract. I want to know how can i get the Clients who didnt renew the contract in 2 month after the end of the contract, is it possible ? if yes can you explain me how to do that please.

(again sorry if my english is not clear).