Hi friends,
i need some suggestions, actually i have a single query/table which has a field/column according to which i want to seperate and obtain seperate query for as per each field but dynamically. I know i can create a parameter and then create a function to invoke filtered tables. But i need a single M Code/or function which can automatically seperate tables for me instead of invoking function again and again. Please guide. I am sharing excel file for reference as source and i want to seperate tables by depttype column in power query in power bi.
thanks and regards
data.xlsx (8.7 KB)
*** READ FIRST ***
Before you send your question.
Make sure that all details relevant to your question is complete:
- Your current work-in-progress PBIX file - VERY IMPORTANT
- A clear explanation of the problem you are experiencing
- A mockup of the results you want to achieve
- Your underlying data file
Check out this thread on Tools and Techniques for Providing PBIX Files with Your Forum Questions
Also make sure that your data file contains no confidential information. If it does, click the link above.
*** DELETE THIS MESSAGE IF YOU ARE SURE ALL YOUR DETAILS ARE COMPLETE OR IF THE ABOVE INFORMATION IS NOT APPLICABLE TO YOUR QUESTION.***