Blogs

Be the first person to 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 ...
0 comments
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
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
Be the first person to recommend 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 ...
0 comments

Funcion en Power Query

Be the first person to recommend this.
Cuando se hacen muchas transformaciones en los datos sobre un dataset y sabemos que tendremos que repetir dichas transformaciones sobre nuestro dataset (o Query), una funcionalidad muy interesante a considerar es crear una   Funcion de Power Query   (Power Query Function), e invocarla cuando la necesitemos para transformar otros datasets. Las ventajas son obvias. Por un lado ahorramos mucho tiempo -sobretodo en grandes transformaciones- aplicando todos esos pasos a otros Queries; y por otro lado reducimos el riesgo de cometer errores en transformaciones futuras, ya que todos los errores los corregimos la primera vez. Debe tenerse en cuenta que para aplicar ...
0 comments
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
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
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
Be the first person to recommend this.
Power BI ha agregado recientemente nuevas funciones DAX que amplian las capacidades estadisticas de analisis de datos. A continuacion presentamos un breve resumen y descripcion de estas nuevas funciones: ·         NORM.DIST Devuelve la distribución normal para la media especificada y la desviación estándar. Esta función tiene una amplia gama de aplicaciones en estadística, incluidas pruebas de hipótesis. Sintaxis NORM.DIST(x,mean,standard_dev,cumulative) Argumentos X requerido. El valor por el que desea la distribución. mean requerido. La media aritmética de la distribución. Standard_dev Requerido. La desviación estándar de la distribución. ...
0 comments
Be the first person to recommend this.
Sin duda, una de las caracteristicas mas esperadas y requeridas por multitud de usuarios en Power BI, es la de poder relacionar tablas usando la relacion 'many-to-many'. Esta funcion fue activada en Julio 2018, y quisiera explicar como funciona. Con la función de relación ‘Many-to-Many (muchos a muchos) en Power BI Desktop, puede unir tablas con una cardinalidad de Muchos a muchos y crear modelos de datos que contienen varias fuentes de datos de forma más fácil e intuitiva. Lo primero que debemos hacer es activar la capacidad ‘Composite Models’ en Power BI Desktop: File > Options and Settings > Options > Preview Features , seleccione  composite ...
0 comments
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
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
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
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
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
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
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
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
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
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