3 months due from specific date

[Anonymous]

Hi,

I want to check if the given date is due from 3 months.

Ex: I have a column expiry date 

I need to calculate which dates are 3 months due from the expiry date

Expiry Date	Is due from 3 months or not?
14/11/2022	No
20/11/2022	No
15/08/2022	Yes

Regards,
Ashfiya

[Jihwan_Kim · Accepted solution]

Hi,

Pleasre check the below picture and the attached pbix file.

It is for creating a new column.

Is due from 3 months or not CC =
VAR _today =
    TODAY ()
VAR _3monthsfromtoday = _today - 90
RETURN
    IF ( Data[Expiry Date] >= _3monthsfromtoday, "No", "Yes" )

[FreemanZ]

hi Jihwan, 

Very curious, how to upload a attachment in a post?

[Jihwan_Kim]

Hi,

I think, instead of uploading files to here, one of other ways to share sample files is, you can share a link (Onedrive, googledrive, Dropbox, or others) of your sample pbix file here. And then other readers of your post can easily access to your sample file.

I hope this helps.

Thank you.