Forum Discussion
Converting days into months
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!
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)
2 Replies
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)