If you’re interested in cascading parameters and Power BI custom connectors is an option for your project, you should give a try to Navigation Tables. Which soon enough could make their way into M standard library. If this is not an option, you might find your solution in the next few scrips tangled between functional programming concepts. You will also learn about:
- Where to set the allowed values for function parameters
- How to build a function inception with higher order functions
- How to access a variable outside its scope
- And finally get to a result which mimics cascading selectionsRead More »