Forum Discussion
Solved
Iterative Lambda with indirect
Hi everybody, I would appreciate your help in order to build an Iterative and generic Lambda with indirect to replace basic Nested If formula Inputs : One CLPC_Status Excel table with Tab_Name and...
Power Query option attached
Note that the 1st Refresh within an Excel session takes more time (time for the .Net Framework to load) that the next Refresh(es)
Hello Lorenzo
Congratulations ! Your PQ solution is just amazing. The only drawback is that the query needs to be refreshed when a user make any modifications in the Tab_CLPC_ijk tables, but the refresh is almost instantaneaous
My complete goal is however slightly more complex. The complete equation I need has one more line (1) that acts as a global enable for the 3 following lines which you kindly realized through a PQ
I will try to modify your query in ordere to add that extra condition, and may be if I can't you will be kind enough to help me again
With Best Regards