Forum Discussion
Nested IF statements in power query
Hi Power-Bi Experts, I need help with the correct syntax for a nested if statement(s) to identify students who have completed a qualification, and students who have met the criteria to progress t...
HI MagubaneSSP,
Account to your description, I think Dax expression should be more suitable for your requirement. Can you please share a pbix or some dummy data that keep raw data structure with expected results?
How to Get Your Question Answered Quickly
Notice:
The power query formula is good at the shape and transforms table structure, then you can simply use these records to design reports. (for this requirement, you need to extract current table records to use as parameters and looping/check matched records with conditions, they needed to use complex nested M query functions with poor process performance)
Regards,
Xiaoxin Sheng