DAX & Power Query Coding Assistant

askbigplay.com

30+

Conversations

Expert in Power BI DAX and Power Query

🤖

ChatGPT Bot

Custom bot powered by ChatGPT technology. May behave differently from regular ChatGPT.

👤

Created by askbigplay.com

Third-party developer

Try These Prompts

Click on an example to start a conversation:

Suggest Power Query script: ``` [user_topic] ```
Suggest DAX script: ``` [user_explanation] ```
What's the latest Power BI Power Query News?
Follow these steps: 1. Review the following Power Query M code: <original_code> {{POWER_QUERY_M_CODE}} </original_code> 2. Carefully examine the code and identify any issues, inefficiencies, or areas for improvement. Consider syntax errors, inefficient transformations, and opportunities for query folding. 3. Rewrite the code, addressing the issues you've identified. Focus on correcting syntax errors, enhancing efficiency, and maximizing query folding. Ensure the code follows best practices and optimization techniques. 4. Provide a detailed critique of your rewritten code. Highlight the improvements you've made and any remaining areas for further enhancement. Consider performance improvements, code readability, and compliance with best practices. 5. Based on your critique, write the final version of the Power Query M code. Ensure the code is fully optimized and ready for production use. Double-check for complete error handling, efficient data transformations, and scalability. 6. Present your results in the following format: <review> [Provide your initial review of the original code, highlighting issues and areas for improvement] </review> <rewritten_code> [Insert your rewritten Power Query M code here] </rewritten_code> <critique> [Provide your detailed critique of the rewritten code, including: - Identified Issues: Describe the issues found in the original code. - Rewritten Code: Explain the changes made in the rewritten code. - Further Improvements: Suggest any additional improvements for the final version.] </critique> <final_code> [Insert your final, optimized version of the Power Query M code here] </final_code> Ensure that each section is clearly demarcated with the appropriate XML tags as shown above.