Show date by 60,120 days

[DimaMD]

Hi,

what measure can show the date which will be in 60,120 days

if I have a date 07/10/2021 it should show 06/12/2021
thanks for the help

[VahidDM]

Hi @DimaMD 

add 60 to the date, for instance:

measure = today()+60 or

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!

[DimaMD]

Hi, @VahidDM 
This measure is great, but I have a table and I have to see the payment date which will be the date in 60-120 days
Example table

Shopper ID	Date of purchase	Payment date 60 days	Payment date 120 days
1	01.08.2021
2	05.07.2021
3
4	07.10.2021

My measure is

CALCULATE(

MIN(Table[Date of purchase] ),

REMOVEFILTERS('Table'))+60
The result that I am does not suit me, I don't want to see this date 28/02/1900

Shopper ID	Date of purchase	Payment date 60 days	Payment date 120 days
1	01.08.2021	30.09.2021
2	05.07.2021	03.09.2021
3		28.02.1900
4	07.10.2021	06.12.2021

[VahidDM · Accepted solution]

@DimaMD 

try this:

Measure=
IF (
    ISBLANK ( MAX ( Table[Date of purchase] ) ),
    BLANK (),
    CALCULATE ( MIN ( Table[Date of purchase] ), REMOVEFILTERS ( 'Table' ) ) + 60
)

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!

[DimaMD]

@VahidDM 
Working measure, Thank you very much