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

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.


Click here and Go to My LinkedIn Page


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.


Click here and Go to My LinkedIn Page


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.


Click here and Go to My LinkedIn Page


Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

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.