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
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
Solved! Go to 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" )
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.
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.
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.