Skip to main content
cancel
Showing results for
Search instead for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

## 3 months due from specific date

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

1 ACCEPTED SOLUTION
Super User

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" )
``````

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Click here and Go to My LinkedIn Page

3 REPLIES 3
Super User

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" )
``````

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Click here and Go to My LinkedIn Page

Super User

hi Jihwan,

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

Super User

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.

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Click here and Go to My LinkedIn Page

## Helpful resources

Announcements

#### Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

#### Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors