Coluna Calculado

[RODRIGO_teixeir]

Hello people,
I have the following problems, through my freight and customer issuance table, I was able to identify the number of days by the previous date, in the case if it is greater than 60, the customer is reactivated, but I wanted him to be reactivated for 30 days, I can't get him to verify that he reached 60 days before the last purchase of that date is counted until 30 days after.

.

[V-lianl-msft]

Hi @RODRIGO_teixeir ,

Could you provide more details?

You could see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[RODRIGO_teixeir]

I'm trying to do the following calculation: I have the table with customer, billing date and billing, I would like to build a condition to search the previous date of the last billing in the context of the line, example: client A, billed on 03/03/2020, previous date 03/01/2020 , with the previous date I would like to return the number of days to know if it is greater than 60 it is in the condition of reactivated as attached, from the date of reactivation I have to add the values ​​up to 30 days after the conditions of activated.