NY/NJ Power BI User Group

PBIUGNYNJ.jpg

Latest Discussion Posts

  • Hi Nathan, That worked out perfectly, thank you. I originally had it as "% Rev = Total[Total Revenue] / Total[Total Budget]", which I'm guessing would still be wrong since my Total query is just a combination of all three sheets, therefore using wrong ...

  • Morgan,   Based on a quick review of your files, It appears that you are calculating [% Rev] in the "Total" Table at the Program Level.  When you add the [% Rev] to the visualization, it is summing all the values in the [% Rev] column and then filtering ...

  • Hello everyone, I have attached a Power BI report I am seemingly struggling on along with the excel spreadsheet being used. Excel Spreadsheet The first tab labeled "SAY" is an overview of all the data.  The only data that changes is the actual ...

  • Good afternoon group, I have a formulated measure that accumulates 12 months per year. For example, the 1-2018 column accumulates from February 2017 to January 2018, but the 12-2017 column accumulates from January 2017 to December 2017. Rolling 12 ...

  • Brian, Once you have your token, you should be able to use the following in advanced editor: let Source = Json.Document(Web.Contents("https://data.nj.gov/resource/qfwz-btpu.json", [ApiKeyName = [#"X-App_Token"="<Your_App_Token>"]])) in Source ------------------------------ ...

  • Profile Picture

    API connection issues

    There is a data set that I want to connect to and I'm having issues and I'm not sure if it's a) possible or b) what do I need to do to make it work. There are two API options available one for JSON and the other for GeoJSON.  I'd love to know the difference ...

  • As a follow up to our July meeting, the latest App In A Day (AIAD) schedule has not been released yet.  Will let you know when I get it. Here is a link to resources you can use in the meantime: https://powerapps.microsoft.com/en-us/blog/microsoft-powerapps-learning-resources/ ...

Announcements

  • Next NYC meetup: Microsoft Industry Accelerators and Dataflows (Common Data Model)

    Introduction to Microsoft Industry Accelerators and Dataflows (Common Data Model)
    Power BI Dataflows help business analysts ingest, transform, integrate and enrich data using the Power Query experience already familiar to Power BI Desktop and Excel users. Join this session to learn how to easily prep your data, leverage Microsoft’s standardized schema, the Common Data Model, improve time-to-value, eliminate data silos, and create one source of truth for your organizational insights.

    Our speaker, Sonal Bordia, is a Microsoft Partner Technical Architect.
    Prior to Microsoft, Sonal was an independent Dynamics 365 consultant helping small to large companies, consulting firms, & Govt industries successfully build, deploy, and manage Dynamics-powered solutions. She has also worked with the Dynamics product team and provided feedback to help expand Dynamics usage with customers in the Northeast.

    Agenda:
    6:00pm - Pizza and networking
    6:30pm - Presentation
  • Peter Meyers presentation - Four Modes of Power BI Desktop

    Thanks to all who came out last night for Peter Meyers' presentation on the Four Modes of Power BI Desktop. It was very informative. Here's a link to the presentation:

    https://bit.ly/petermyers_ug_20181004

Latest Shared Files


  Log in to see this information

Current Members
205 Members
user group Admin
user group Admin
user group Admin
user group Admin