Things that make you go "M"?

Things that make you go "M"

Wyn Hopkins Wyn Hopkins

Wyn Hopkins

Leading a team that solves data challenges for companies and people Power BI | Excel | Fabric | Solver Budgeting & Consolidation. Control costs, reduce risk and assist growth Microsoft MVP ??5 Million+ YouTube views

发布日期: 2019年1月30日
+ 关注

"M" ( short for mashup ) is the language of #PowerQuery

This video is a quick use case for List.Contains to group items into an "Other" bucket.

Plus it contains a couple of tips on finding out more about "M" formula.

All sorts of useful formulas are available once you step past the amazingly user friendly buttons.

#Excel #PowerBI


www.accessanalytic.com.au/blog
Wyn






要查看或添加评论，请登录

Wyn Hopkins的更多文章

  • The Best Dependent Drop Down Technique
    2024年11月15日

    The Best Dependent Drop Down Technique

    Driven by a gauntlet laid down by friend and fellow MVP Mark Proctor on our Unpivot podcast recently I revisited my…

    1 条评论
  • Should you use Measures for Conditional Formatting?
    2024年6月9日

    Should you use Measures for Conditional Formatting?

    Streamline Your Power BI Conditional Formatting with Measures I've always found the built-in conditional formatting in…

    6 条评论
  • Consolidate and Hyperlink to Excel files on SharePoint
    2024年1月3日

    Consolidate and Hyperlink to Excel files on SharePoint

    In this video, we're diving into the world of Excel and Power BI, focusing on creating hyperlinks for easy referencing…

    4 条评论
  • The greatest multi-level Excel drop-down list ever!
    2023年11月3日

    The greatest multi-level Excel drop-down list ever!

    One-Off dependent drop down lists in data validation are relatively straightforward: here's a technique using XLOOKUP…

    5 条评论
  • Default Your Slicer to the Current Month in Power BI
    2023年7月31日

    Default Your Slicer to the Current Month in Power BI

    First Published November 2022 on our YouTube Channel Join 65,000+ subscribers to stay up to date with new videos…

    4 条评论
  • Power BI Licensing Explained
    2023年5月27日

    Power BI Licensing Explained

    What are the differences between: Power BI Free (soon to be renamed Fabric Free) Pro: $10 USD pp/pm PPU (Premium Per…

    2 条评论
  • Power BI May 2023 Release
    2023年5月26日

    Power BI May 2023 Release

    The May version of Power BI desktop is out This is a very quick post highlighting my 2 favourite picks: 1. Azure Maps…

    5 条评论
  • Simpler DAX ? = Power Query
    2023年5月12日

    Simpler DAX ? = Power Query

    If you are struggling to write a complicated DAX formula then the answer may be to step back and do a little Power…

    2 条评论
  • Power BI Explained
    2023年3月29日

    Power BI Explained

    A simple explanation of Power BI I hope you find this useful. Power BI continues to go from strength to strength and…

  • SUMX explained.
    2023年2月27日

    SUMX explained.

    SUMX is a DAX function that can be used in an Excel Data Model (aka Power Pivot) to create a temporary column…

    6 条评论

社区洞察

其他会员也浏览了