Converting days into months

[Anonymous]

Hi

I am working with a sett of data that tells me at what time a certain product will expire. I have the number of days untill the expiering day, but I wish to represent it as number of months. Also, if it is possible I want Power BI to show me the exact expiering date.

In advance, thank you for all your advices!

[d_gosbell · Accepted solution]

If you have the number of days from today until the expiry you could do something like the following to calculate the expiry date

Expiry Date = UTCNow() + DaysTilExpiry

Then you can calculate the difference between now and the expiry date in months using the DATEDIFF function

Expiry Months = DATEDIFF( utcnow(), [Expiry Date], MONTH)

[Anonymous]

Perfect, thank you! 🙂