Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
52
Views
Topic starter
I have an excel formula which returns a age banding based upon volume -
=IFS(S4>365,"365+",S4<=30,"Not Due",AND(S4>=31,S4<=60),"31-60",AND(S4>=61,S4<=90),"61-90",AND(S4>=91,S4<=120),"91-120",AND(S4>=121,S4<=365),"121-365")
S4 = "No Days old".
I am looking to replicate the formula in Power Query. How would I construct the formula?
Please bear with me I am new to Power Query.
Thank you in advance
Posted : 12/03/2020 11:03 am
Hi Michael,
Welcome to our forum!
This IFS formula is the equivalent of an approximate match VLOOKUP and I wrote a tutorial on replicating an approximate match VLOOKUP with Power Query.
I hope that points you in the right direction.
Mynda
Posted : 12/03/2020 9:08 pm