Forum Discussion

morphil's avatar
morphil
Copper Contributor
Apr 23, 2023
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...
excel
Formulas and Functions
office 365
  • Lorenzo's avatar
    Lorenzo
    Apr 27, 2023

    morphil 

    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)

morphil's avatar
morphil
Copper Contributor
Apr 27, 2023

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

Lorenzo's avatar
Lorenzo
Silver Contributor
Apr 27, 2023

Hello morphil 

You're finally far from an iterative lambda ;-)). Anyway, if you need help with Power Query I suggest you open a separate thread/discussion (ref. that one for background if you think this is important)

 

Best..

Resources