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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
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/2022No
20/11/2022No
15/08/2022Yes

 

 

Regards,
Ashfiya

1 ACCEPTED SOLUTION
Jihwan_Kim
Super User
Super User

Hi,

Pleasre check the below picture and the attached pbix file.

It is for creating a new column.

 

Jihwan_Kim_0-1668413166392.png

 

 

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.


Visit my LinkedIn page by clicking here.


Schedule a meeting with me to discuss further by clicking here.

View solution in original post

3 REPLIES 3
Jihwan_Kim
Super User
Super User

Hi,

Pleasre check the below picture and the attached pbix file.

It is for creating a new column.

 

Jihwan_Kim_0-1668413166392.png

 

 

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.


Visit my LinkedIn page by clicking here.


Schedule a meeting with me to discuss further by clicking here.

hi Jihwan, 

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

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.


Visit my LinkedIn page by clicking here.


Schedule a meeting with me to discuss further by clicking here.

Helpful resources

Announcements
September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors