SUMX explained.

SUMX explained.

Wyn Hopkins Wyn Hopkins

Wyn Hopkins

Solving data challenges for companies and people. Power BI | Excel | Fabric | Solver Budgeting & Consolidation. Part of the Amazing team at Access Analytic Microsoft MVP ??6 Million+ YouTube views

发布日期: 2023年2月27日
+ 关注

SUMX is a DAX function that can be used in an Excel Data Model (aka Power Pivot) to create a temporary column containing a calculation for each row which can then be summed.


This is a follow on from the last post on XLOOKUP v Power Query v Power Pivot



00:00 Intro

00:30 Recap

03:50 How does SUMX work

05:10 Writing a SUMX


We run Power BI and Excel Training in Australia and beyond

Check out my book "Power BI for the Excel Analyst"

Wyn

No alt text provided for this image
Abdul Said M K.

Group Financial Controller @ GILDA Group

2 年

Do DAX Functions have all the excel functions as well ?

赞
回复
查看更多评论

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

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…

  • XLOOKUP v Power Query v Power Pivot
    2023年2月7日

    XLOOKUP v Power Query v Power Pivot

    When combining tables in Excel there are several options. In this video I show you XLOOKUP, Power Query Merge and a…

    5 条评论

社区洞察

其他会员也浏览了