Blogs

My Top 5 Reasons for Taking Power Academy Classes

By Sue Whitney posted 12 days ago
Be the first person to recommend this.
I’ve had the opportunity to attend several Academy classes: The CRMUG Administrator Blue belt and purple belt classes, Academy Excel Power Pivot, and Academy Power BI Blue belt.  Here are my top 5 reasons for taking these classes: 1. Lifelong Learning is a Positive Experience The benefits of lifelong learning are numerous: it helps you enhance your mind and keeps your thinking sharp. Learning also keeps the creativity flowing and it’s also been scientifically proven that active learning is a great exercise for the brain- which is an area I want to keep in top shape. 2. Expands My Skill Set I love my job and where I work but that doesn’t mean I ...
0 comments

Our first Power BI custom visual - Column Chart with Variance

By Matthew Gierc posted 10-26-2018
Be the first person to recommend this.
Hello Power BI Enthusiasts! A few months ago we published our first Power BI custom visual titled Column Chart with Variance. It's free, and you can find it  here .  So far we've had good feedback from people who have used it, but we're always interested in getting more, especially from "Power" users. Please feel free to hit us up with any comments or questions. Also, we wanted to share a little about our philosophy behind developing this visual. If you're interested in learning more, please check out our blog post .
0 comments

Free-to-use Power BI Tutorial Report

By Stephan de Jong posted 10-10-2018
2 people recommend this.
Hi fellow Power BI enthousiasts! To properly set up the use of Power BI within your organization, it is usually necessary to give users some training. For users who only consume reports a short training, in which the possible interactions of a Power BI report are explained, is often sufficient. One way of doing this is by using a step-by-step tutorial report, that can also serve as a reference document within Power BI itself. In the past few months I have already built such a Tutorial for some of my customers, which they are now using in their Power BI Apps. For those of you who are also interested in adding a Tutorial to their Power BI environment, I am ...
3 comments

Search exactly matched String/Text in PowerBI

By Ranjit M posted 10-09-2018
Be the first person to recommend this.
Hi, I want to search exactly matched String/Text from multiple columns. FYI below, If i search for ServiceName='NETWORKING' then it should display matched records. Please suggest me how to achieve this.
0 comments

Developing with Power BI Embedding

By Ted Pattison posted 10-04-2018
Be the first person to recommend this.
In the three years since its initial release, Power BI has become widely-adopted by corporations and other organizations as a Software-as-a-Service (SaaS) application. The Power BI Service provides licensed users with the ability to access and interact with Power BI reports and dashboards through the Power BI portal which most users access through the URL of https://app.powerbi.com. The Power BI Service also provides licensed users with a first-class mobile experience using the Power BI Mobile apps that Microsoft has published for iPhone, Android and Windows 10. Microsoft promotes Power BI along with PowerApps and Flow as the primary services in the Microsoft ...
0 comments

Data Modeling 101 with Power BI

By Erich DeJesus posted 09-18-2018
1 person recommends this.
Hello All,  This is our second ATL local workshop  Data Modeling 101 with Power BI  Data is available in many forms. Structuring the data in a way that is easy to consume often presents a challenge. In this session, we will walk through some basic Data Modeling techniques that can be done using all the tools built into Power BI. If that isn’t enough, we will also show you how to centralize the completed model, presenting a central version for all end-user reporting. Bring your laptop, because this is a hands-on lab. Agenda 30 min 11:30 AM Arrivals and Networking: 60 min 12:00 PM Lunch by Provided Aptude, Inc 120 min 1:00 PM - 3:00 PM Workshop ...
1 comment

Calculating pervious and current sales in direct query

By PANTRY COUPON posted 09-04-2018
Be the first person to recommend this.
Hi All. Im new to PBI. Im getting data from Hana. what is the best direct query formula to calculate PY and CY  sales  Please Help Thanks P
0 comments

Calculating pervious and current year sales in direct query

By PANTRY COUPON posted 09-04-2018
Be the first person to recommend this.
Hi All. Im new to PBI. Im getting data from Hana. what is the best direct query formula to calculate PY and CY  sales  Please Help Thanks P
0 comments

Connecting with Users through the PowerBIUG Partner Program Benefits Business

By Sue Whitney posted 08-22-2018
Be the first person to recommend this.
How Connecting with Users through the PowerBIUG Partner Program Benefits their Business   An interview with Ben Douglass, Global Marketing Director, ZAP (PowerBIUG): What’s your favorite part about being part of the PUG Community? (BD) : The best part is getting the chance to discuss the challenges of data preparation and governance with Power BI users. It also gives our experts a platform to share their experiences and knowledge on the subject to PUG members. We enjoy attending events and spending time with the community face-to-face – it’s good to get the chance to meet people (outside of the constraints of email!) and get a sense of what’s on ...
0 comments

Azure data sources in Power BI

By Erich DeJesus posted 07-26-2018
Be the first person to recommend this.
Join Patrick Leblanc and Erich Dejesus on a  hands-on workshop where we will demonstrate how to leverage Power BI to connect to various Azure-based data sources. They will connect to sources such as Data Lake, CosmosDB, Blog Store, Azure SQL, Azure SQL Data Warehouse, etc.. Step-by-step details will be provided so that each attendee leaves with skills and knowledge to implement this when they are back at their desk. The only requirement is to have an Azure subscription you can create one free in this link   https://azure.microsoft.com/en-us/ This event is only for local user in ATL . Register Here: https://www.eventbrite.com/e/azure-data-sources-in-power-bi-tickets-47919398210
0 comments

Power BI World Tour -- Meet Your Speakers!

By Jena Coffie posted 07-24-2018
Be the first person to recommend this.
The Power BI World Tour sessions for first three cities of this global tour are now available! Get a look at the popular topics and sessions planned for you, and get to know your speakers! Melbourne (August 21-22) Kelly Broekstra David Alzamendi Charlotte (August 28-29) Melissa Coates Angela Henry Sydney (August 28-29) Peter Myers More speakers and details are being confirmed each day so check back regularly for updates! www.powerbiworldtour.com #PowerBI #PowerApps #Flow #PBIWorldTour ​​​
0 comments

New Features & Look for the Power BI User Group (PowerBIUG)!

By Marghet Hager posted 07-18-2018
Be the first person to recommend this.
We are very excited to announce that  PowerBIUG   (formerly PUG) has a fresh new look! On top of that,  we are excited to  introduce  PowerAppsUG   –   a new site to connect PowerApps users with each other.   L et’s take a tour of some of the new personalized features which will help you better see relevant discussions and upcoming events.   Easily Access User Groups   With the new Utility navigation on the top bar, you can seamlessly access  PowerBIUG ,  PowerAppsUG , and other user groups without leaving the site. You can use your same login credentials for the User Group for Dynamics 365 ( D365UG.COM ) site, giving you ...
0 comments

July PUG of the Month Winner

By Quinne Germain posted 06-29-2018
Be the first person to recommend this.
Congratulations to @Maja Franješ  and the Zagreb PUG on winning the July challenge of the month. We spent some time with Maja to learn more about this community in Zagreb.   What has been the most exciting thing for your PUG so far?  The most exciting thing has been when we realized that all available seats were reserved by group members a week before our first PUG meeting. We have received emails asking for additional seats.   What makes your group successful? Definitely a great team!  None of this was possible without the help of an excellent team that helps in the preparation of promotional materials, finding lecturers and sponsors, ...
0 comments

Memories of DATA & BI Summit 2018 | Dublin, Ireland.

By Anil Maharjan posted 06-27-2018
Be the first person to recommend this.
The journey which we have thought in our mind but couldn’t make it happen due to different things. But this year I got an opportunity to represent myself, my country Nepal and overall Nepal Power BI User Group in DATA and BI Summit 2018 which was held in Dublin, Ireland on 23rd April to 25th April, 2018 at The Convention Centre Dublin. https://www.databisummit.com/home https://www.pbiusergroup.com/kathmandu I was also appointed to be a Program Committee member for this DATA and BI Summit 2018 in Visualize Track, where we team up in group to review different abstracts from different great speakers around the world. We work really hard to finalize the ...
0 comments

Analisis Predictivo con Power BI

By Pablo Moreno posted 06-11-2018
1 person recommends this.
Es cierto que Power BI es una aplicacion bastante versatile a la hora de visualizar y analizar datos, y aunque se menciona en varios blogs y white papers las capacidadesd de analisis predictivo o Machine Learning (al margen de usar el R script ), aqui presento un compendio de las funcionalidades que ya existen para tal fin sin necesidad de usar codigo en R o ningun otro codigo. En cuanto a los metodos o funcionalidades de analisis predictivo, vamos a distinguir entre las capacidades 'propias de Power BI' y las visualizaciones que actualmente estan disponibles en el ‘AppStore’ de Microsoft para Power BI. No es la intencion de este blog de describir o explicar ...
0 comments

Brief Overview of the Project Professional Program

By Tommy Puglia posted 06-11-2018
1 person recommends this.
I wanted to give a summary of what the Tampa Power BI User Group has started to integrate in our monthly meetups - many of you have heard about the Project Professional Program. We have already covered 3 sessions (overview, data modeling, and query editor), and if you are interested below is what we are covering and the goals of the series: Overview: To educate & train Tampa PUG members on building Power BI Reports by guided & interactive sessions via using the “Dashboard in an Hour” (DIAH) or Workshop format. The workshops & sessions will focus on best practices, advanced features & how to implement in reports, and providing solutions by ...
0 comments

Previous Row Value in Power Query

By Andy Parkerson posted 05-27-2018
Be the first person to recommend this.
Someone asked how he could get a calculated column with the value for a certain column in the previous row. In Excel, this is a simple task. However in M, things become a bit more tricky. Suppose you are taking measurements, and for some reason you want the previous measurement to be stored with your data. There are optimization concerns that may make this a useful thing to do, as Power Query only performs its actions on refresh, and not once the data loaded. Alternatively, DAX does it’s work every time you select a slider, click a visualization, or basically change anything on the report. This is one of the times when a good SQL background helps your M ...
0 comments

Counting Measure Results

By Andy Parkerson posted 05-27-2018
Be the first person to recommend this.
Someone had written a measure that gave a certain range of outputs, such as “A”, “B”, or “C”. They had a process that gave a grade to each order depending on how well it performed in certain ways — how fast it was shipped, how many times the customer called in, how much profit was made, etc. They then wanted to know how many As, Bs, and Cs were given. In short, they wanted to be able to count the measure results. When you want to measure other measures, you need the iterative functions (a.k.a the “X” functions). In this case they wanted  COUNTX() . I threw together an example PBIX with some random data. I have 4 data measurements each day ( M1  –  M4 ...
0 comments

Start of Current Month in Selected Year

By Andy Parkerson posted 05-26-2018
Be the first person to recommend this.
Someone asked how he could find the start of the current month in a different year. He had a report that contained a parameter that selected a year, say 2007. He wanted to find the beginning of the current month, say May, in that year. So what he wanted was the string "May 1, 2007" when the current date was May 26, 2018. And if the current date were October 5, 2023, he would want the string to read "October 1, 2007". Whenever you talk about dates in Power BI, you have to know how dates are stored. In this case, the date table was created with the DAX function Dates = CALENDAR(DATE(2001,1,1), TODAY()) That gives you a table named Dates with a column named ...
0 comments

Patrick LeBlanc comes to DC!

By Shannon Lindsay posted 05-03-2018
Be the first person to recommend this.
Have you wondered what the right approach is for creating and deploying your Power BI content? Which tools are the right ones? When do you use app workspaces and apps? How to understand your licensing options? And how to keep your data up to date? Microsoft's own Patrick LeBlanc is coming to DC to help us answer these questions! Join us to hear from Patrick and to network with fellow data people!  You can visit our DC PUG page here, or find us on Meetup  for more details! If you're in the DC area (or even if you're not), follow us on Twitter @Power_BI_DC ​ for Power BI-related news, blogs, and articles! We hope to see you there!  Shannon and Gio
1 comment