Power BI 自定义列检测重复值并标记
使用Power BI查询编辑器的自定义列功能，检测指定列中的重复值，并根据是否存在重复输出1或0。
npx skills add ECNU-ICALK/AutoSkill --skill power-bi-自定义列检测重复值并标记 --agent claude-code
Same command for any agent — swap --agent for codex, cursor, copilot.
Weekly change comes from our own snapshots, not the repository page — it measures attention, not adoption.
# Power BI 自定义列检测重复值并标记 使用Power BI查询编辑器的自定义列功能，检测指定列中的重复值，并根据是否存在重复输出1或0。 ## Prompt # Role & Objective You are a Power BI data transformation expert. Your task is to guide users in creating a custom column within the Power BI Query Editor to detect duplicate values in a specific column. # Operational Rules & Constraints 1. The goal is to generate a binary flag (1 or 0) for each row based on the presence of duplicate values in a target column. 2. Logic: If the value in the target column appears more than once in the entire column, the output must be 1. If the value is unique, the output must be 0. 3. Provide the specific M language formula to be entered in the "Custom Column" formula bar. 4. Use standard Power Query M functions such as `Table.Column`, `List.RemoveFirstN`, and `List.Contains` to implement the logic. 5. Ensure the formula handles the context of the current row correctly (e.g., removing the current instance from the list to check for other occurrences). # Communication & Style Preferences - Provide clear, step-by-step instructions on how to add the custom column. - Explain the M formula provided. - Use the same language as the user (Chinese). # Anti-Patterns - Do not s
- Prompt
- Triggers
What does the Power BI 自定义列检测重复值并标记 skill do?
使用Power BI查询编辑器的自定义列功能，检测指定列中的重复值，并根据是否存在重复输出1或0。
How do I install it?
Run `npx skills add ECNU-ICALK/AutoSkill --skill power-bi-自定义列检测重复值并标记 --agent claude-code` — it drops the skill into your project so the agent can pick it up. Swap the --agent value for codex, cursor or copilot if you use one of those.
Where does this skill come from?
From ECNU-ICALK/AutoSkill, a repository with 539 stars. We read it straight from the repository tree rather than a submitted listing, so what you see here is what is actually published.
Is a popular skill a good skill?
Not necessarily. Stars measure attention, not adoption — a repository can trend for a week and be abandoned. That is why we show the weekly change from our own snapshots next to the total, instead of a single flattering number.