Central NJ Power BI User Group

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

PUG, Fri, Nov 22, 1pm, Hamilton, NJ

  • 1.  PUG, Fri, Nov 22, 1pm, Hamilton, NJ

    Gold Contributor
    Posted Oct 28, 2019 10:13 PM
    PUG Members,

    The next User Group Meeting is scheduled for Friday, Nov 22, 1pm to 2:30pm in Hamilton, NJ.

    I'll post the event location on our calendar schedule.

    Topics include discussion of the On-Demand training - Power BI Black Belt Series (4 courses).

    Academy On Demand - Power BI User Group

    Agenda:
    - Introductions
    - Discussion of how participants are using Power BI
    - Overview of the On-Demand training
    - Examples that participants may wish to share.

    The meeting will support those who are new or relatively new to Power BI.

    ------------------------------
    Jerome Scriptunas
    Central NJ PUG
    ------------------------------


  • 2.  RE: PUG, Fri, Nov 22, 1pm, Hamilton, NJ

    Gold Contributor
    Posted Nov 24, 2019 10:48 AM
      |   view attached

    Central NJ PUG Meeting, Friday, Nov 22, 2019, 1pm-2:30pm, Hamilton Township
     at New Jersey Association for Mental Health and Addiction Agencies (NJAMHAA)

    Participants: Jerome S, Ron G, John K, Sunita A, QaDing S, Di L, Lisa C-H, Susan A, Kiera L

    Organizations: YTBNJ.org, NJAMHAA.org, NJ State DHS, NJ State DMHAS, Key Autism Services, Middlesex County Government, Cope Center, Enable, Inc., Integrity House

    Topics of discussion:

    • Getting Started: Learning Power BI and installing Power BI Desktop
    • Connecting to data & Data drill down
    • Data relationships, integrate data sources
    • Data visualizations
    • DAX example of "ThisExists" or "IsTrue" (see below)
    • Power BI Free and Power BI Pro; Query Editor (M language) & Report Mode (DAX language)
    • Using PBI with SharePoint Online Lists
    • Q&A continued from 2:30-3:30pm
    • Considering offering hands-on practice via webinar

    Meetings in 2020 under consideration for

    • Monmouth County at Freehold Raceway Mall or Manalapan Library;
    • Mercer County at NJAMHAA;
    • Ocean County at one of the colleges-universities.

     

    DAX for "ThisExists"

    YTBtrue = CALCULATE(COUNTROWS(YTB), FILTER (YTB, YTB[YouthID] = EARLIER(Members[YouthID]) ) ) > 0

    In this DAX, YTB refers to a data table that includes entries for youth participating in a community practice called 'YTB'.  The youth are identified by their youthID.  Another data table includes data for all youth enrolled with a community organization.  Some of these youth participate in YTB.  The DAX above for "YTBtrue" is a column that is added in Power BI desktop to the primary data table or query in the Fields panel (right-most panel) in the Report mode (or canvas) of Power BI Desktop. The purpose of this DAX is to return a value of True or False.  A value of True is returned if the YouthID exists in the YTB data table as well as the data table for all of the Members.  Otherwise a value of False is returned. 

     

    The DAX for "IsTrue" is useful for creating exception reports.  Organizations use this DAX to identify which enrollees have not been visited, or for which no activity notes have been entered for the current week, or which individuals are not represented in some category.  Many times we know or have data to show what is occurring.  The DAX for "IsTrue" helps us to see what is not there.  The DAX can be named however you like: "IsTrue", "SometihngExists", "Missing", or your choice.

     



    ------------------------------
    Jerome Scriptunas
    Central NJ PUG
    ------------------------------

    Attachment(s)

    pdf
    PUG-20191122.pdf   149K 1 version