Code Monkey home page Code Monkey logo

py-get-dax-m's Introduction

py-get-dax-m

更多内容关注博客:焦棚子

Python 获取 DAX 和 powerquery-m 官方文档信息, 用于代码分析和快速查阅等。

1、python 环境

# 版本:Python 3.9.13

2、安装依赖

pip install -r requirements.txt

3、执行 python 文件

python main.py

# dax 文件, 大约耗时 276.18 秒!
# m   文件, 大约耗时 386.98 秒!

4、json说明

Ⅰ、dax.py 会在项目目录下生成 dax.json 文件。

键名如下:

  • url-en-us : 函数英文版链接
  • url-zh-cn :函数中文版链接
  • description-en-us :函数英文版简短说明
  • category-en-us :函数英文版分类
  • url-category-en-us :函数英文版分类链接
  • category-zh-cn :函数中文版分类
  • url-category-zh-cn :函数中文版分类链接
  • description-zh-cn :函数中文版简短说明
  • url-dax-guide :函数英文版 SQLBI 链接
    {
    "CALCULATE": {
        "url-en-us": "https://learn.microsoft.com/en-us/dax/calculate-function-dax",
        "url-zh-cn": "https://learn.microsoft.com/zh-cn/dax/calculate-function-dax",
        "description-en-us": "Evaluates an expression in a modified filter context.",
        "category-en-us": "Filter functions",
        "url-category-en-us": "https://learn.microsoft.com/en-us/dax/filter-functions-dax",
        "category-zh-cn": "筛选器函数",
        "url-category-zh-cn": "https://learn.microsoft.com/en-us/dax/filter-functions-dax",
        "description-zh-cn": "在已修改的筛选器上下文中计算表达式。",
        "url-dax-guide": "https://dax.guide/calculate/"
    }
}

Ⅱ、m.py 会在项目目录下生成 m.json 文件。

键名如下:

  • url-en-us : 函数英文版链接
  • url-zh-cn :函数中文版链接
  • description-en-us :函数英文版简短说明
  • category-en-us :函数英文版分类
  • url-category-en-us :函数英文版分类链接
  • category-zh-cn :函数中文版分类
  • url-category-zh-cn :函数中文版分类链接
  • description-zh-cn :函数中文版简短说明
    {
    "Excel.Workbook": {
        "url-en-us": "https://learn.microsoft.com/en-us/powerquery-m/excel-workbook",
        "url-zh-cn": "https://learn.microsoft.com/zh-cn/powerquery-m/excel-workbook",
        "description-en-us": "Returns the contents of the Excel workbook.",
        "category-en-us": "Accessing data functions",
        "url-category-en-us": "https://learn.microsoft.com/en-us/powerquery-m/accessing-data-functions",
        "category-zh-cn": "数据访问函数",
        "url-category-zh-cn": "https://learn.microsoft.com/en-us/powerquery-m/accessing-data-functions",
        "description-zh-cn": "返回 Excel 工作簿的内容。"
    }
}

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.