PUG Exchange

Connect with all the Power BI Users in the PUG Exchange! All the user groups have access to this one online forum to collaboratively and instantly share their Power BI projects, wins and struggles.

Latest Discussion Posts

  • What about the following: Add a measure like this to the Sales FACT - Total Sales = SUM(quantity * Cost)  Then add a measure like this to your Store DIM -  Median Sale = MedianX ( Values(Store DIM[Store Name]) , Sales FACT[Total Sales] ) Something ...

  • Have a read of my blog article here -  http://johnbroomfield.com/2018/03/28/mapping-adventures-in-power-bi/ Johnbroomfield Mapping Adventures in Power BI Having just finished work on a project ...

  • Is this close to what you need - https://blog.crossjoin.co.uk/2016/05/30/creating-current-day-week-month-and-year-reports-in-power-bi-using-bidirectional-cross-filtering-and-m/ ------------------------------ John Broomfield Business Intelligence Analyst ...

  • Hello I'd like some assistance please, I have sales data at a transaction level and therefore calculating the median transaction value was straight forward.  I'd now like to calculate the median store value sales. I think I need to summarise/group the ...

  • I need to do a month to data calculation in the query editor so that I can pivot out MTD and other metrics into rows vs. columns. M does not have a MTD function that I can find. Does anyone have an example of how to a MTD custom column in M? ...

Announcements

Latest Shared Files

Community Blogs

  • We all have unique needs when it comes to our jobs. It can be difficult to find ways to customize your education, but Focus, held May 21-24, 2018 in Indianapolis, provides just that! at!  Focus does things a little differently than our traditional ...

    1 person recommends this.
  • Over the last several months the Focus Programming Committee has worked diligently to determine the most relevant and useful session topics for Power BI users and they are ready to share Focus 2018 session details with you! Check out the schedule ...

Latest Volunteer Opportunities


  Log in to see this information

Current Members
41621 Members
user group Admin
user group Admin
user group Admin
Hidden Member
user group Admin