•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Power query - how to find difference in months while accounting for year changes?
We have membership renewal appeals we send out monthly; they are numbered by the membership expiration month's relavitity to the current month and we are on a rolling 7 month basis, starting with 1 for expirations two months out and counting up backward. So for instance it's March, so for this month's appeal it's
| Expiration | Appeal |
|---|---|
| 5/31/26 | 1 |
| 4/30/26 | 2 |
| 3/31/26 | 3 |
| 2/28/26 | 4 |
| 1/31/26 | 5 |
| 12/31/25 | 6 |
| 11/30/25 | 7 |
So to generate the info I want, basically I want the equivalent of SQL
DATEDIFF(mm, [Appeal Date], [Expiration Date]) and I've been down a google rabbithole and I can not get this figured out. It kinda drives me nuts that this doesn't exist in M (I know it does in DAX).
Any thoughts? I guess I could make a helper table in Excel and load that into PQ but it seems like this should be calculatable...
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#Excel alternatives
#rows.com
#google sheets
#financial modeling with spreadsheets
#no-code spreadsheet solutions
#Power Query
#membership renewal
#Expiration Date
#Appeal Date
#DATEDIFF
#rolling 7 month basis
#SQL
#month difference
#Excel
#calculatable
#helper table