Sydney Power BI User Group

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Sydney Power BI User Group

Latest Discussion Posts

  • We're excited to announce that Power Platform World Tour is coming to your region! We're working with Microsoft to get the word out to all users of the Power Platform products to come network and learn more about how to utilize these products. We'd ...

  • We're excited to announce that Power Platform World Tour is coming to your region!   Powered by your local Power Platform User Groups (Power BI, PowerApps, and Flow), the Power Platform World Tour brings actionable education on Power BI, ...

  • 1.  The excel file is missing the "completed" data sets.  Your report is pretty easy to build.  I just don't have enough information. ------------------------------ Richard Nacianceno 76123 Fort Worth 3046902562 ------------------------------

  • There is a lot to learn.  The short answer is CALCULATE().  I suggest you start by reading all the articles in my knowledge base  https://exceleratorbi.com.au/knowledge-base/ Also, the fastest way to get to know everything you need is to read my book  ...

  • Profile Picture

    RE: Countif in power bi

    Please check the below out https://community.powerbi.com/t5/Desktop/DAX-Function-for-COUNTIF-and-or-CALCULATE/td-p/66607 ------------------------------ Carson Tan 0425219570 ------------------------------

Announcements

  • Sydney Power BI Meetup - Dec 2019

    In December we have two speakers Sergei Gundorov and Phil Seamark speaking on PBI newly released security, admin and data modelling features and product posture on the back of these releases.

    Agenda:
    5:30pm: Registration and Networking
    5:45pm: Power BI Updates
    6:00pm: Security, Admin and Data Modelling Features in new PBI Releases by Sergei Gundorov and Phil Seamark
    7:00pm: Q&A and Networking

    Topics:
    Security:
    • MIP/MCAS integration which just got announced
    • BYOK – current status and what will be done by GA; near term limitations and ways to deal with them
    • Multi-Geo for compliance/data residency and what will be coming in the near future
    • VNets status and plans
    Admin, API and Embedding:
    • Admin UI and API enhacements
    • GW API enhacements
    PBIE overview and intro to new and upcoming PBIE features
    Data Modelling:
    • Composite Models/Aggregation awareness (large models)
    • Paginated Reports
    • Debugging DAX and performance issues in Power BI

    Speakers:
    Sergei Gundorov is a Principal Program Manager on the Power BI team at Microsoft. He has a Master’s degree in Business Administration and has published numerous articles over the course of 27 years through multiple channels on various subjects that range from accounting and economics to in depth technical articles on Microsoft Developer Network (MSDN). Sergei’s most recent contribution was to the Security Whitepaper for Power BI updates in March 2019. He has presented valuable technological advancements to worldwide developer audiences at TechEd, TechReady, Difinity, MBAS, etc… conferences. He has participated in and contributed to numerous webcasts focused on technologies in which he is considered an industry expert. He is an inventor and has filed for and obtained several patents related to Microsoft Excel and Excel Services. Sergei runs the popular technical XLGeek’s Space blog where his work is praised highly by readers and users of his apps.

    Phil Seamark works on the Microsoft Power BI CAT team and is an accomplished database and business intelligence (BI) professional. Phil has an in-depth knowledge of the Microsoft BI stack along with extensive knowledge of data warehouse (DW) methodologies and enterprise data modelling. Phil has expert knowledge in all facets of BI/DW including planning architecture, project management, dimensional modelling, performance tuning, ETL design, development and optimisation, report and dashboard design as well as installation and administration.
    Phil has written several books DAX and Data modelling and has also blogged extensively at dax.tips.
  • Sydney Power BI Meetup - Nov 2019

    In November we have two speakers Matt Allington and Iman Eftekhari. Matt will speak on The Finer Points of DAX and Iman will speak on Things you need to know about Power BI Premium.

    Agenda:

    5:30pm: Registration and Networking
    5:45pm: Power BI Updates
    6:00pm: The Finer Points of DAX by Matt Allington
    6:30pm: Things you need to know about Power BI Premium by Iman Eftekhari
    7:00pm: Q&A and Networking

    Topic: The Finer Points of DAX
    DAX is a functional language. It can be simple to get started but can be challenging to master. It is very common for people to be able to copy and/or read a formula that someone else has written and to basically know how it works, yet lack the deeper understanding to be able to write the formula themselves. In this presentation, Matt Allington will explain the nuances of some of the more important functions in DAX, including
    * FILTER
    * SUM vs SUMX
    * The different roles of CALCULATE

    Speaker:
    Matt Allington is a career expert in BI and has 30+ years experience in using data to deliver business value. Matt is a Microsoft MVP that specialises in Power BI, Power Pivot for Excel and Power Query. He brings his business and IT experience to the table to get fast and effective results through training, consulting and general business data problem solving. Matt is the author of the book “Supercharge Power BI - Power BI is Better When You Learn to Write DAX”.

    Topic: Things you need to know about Power BI Premium
    In this session Iman will give you an overview of Power BI Premium. He will answer common questions like:

    What is Power BI Premium? How does it work? How is it different to Power BI Pro? What are the licensing options? What are the considerations before we purchase it? What is Power BI Report Server? …

    Speaker:
    Iman Eftekhari, is passionate about helping organisations unleash the power of their data assets. He has over 20 years’ experience in Data Analytics and Business Intelligence delivering successful projects for various organisations throughout financial services, retail, manufacturing, health, real estate, and the public sector.

Latest Shared Files

Volunteer Opportunities

Details

  There are no volunteer opportunities at this time! Check back later!

Current Members
200 Members
user group Admin
user group Leadership
Group Leader
user group Admin
user group Leadership
Group Leader
user group Admin
user group Admin
user group Admin
user group Admin