My name is Miguel Escobar. A little over 1 year ago I started a forum through my company(Powered Solutions)focused mainly on topics related to Power BI, Power Query and PowerPivot totally in Spanish.
Yes! Just like you read it. A totally free forum for the entire Spanish-speaking community where we helped each other as a community by answering daily inquiries of any kind of complexity level.
All this effort arose because there was no free public community or forum for Power BI-related topics, nor was there much content published in Spanish for these topics compared to what exists in English.
We understood very well the impact of having an active community and content created in Spanish for a tool like Power BI / Power Query / PowerPivot and that's why we take reins on the issue to have a positive impact on Spanish-speaking users looking for such communities and content.
Thus, at the end of 2018 our campaign for the Spanish-speaking community emerged internationally where the forum was one of the main contributions.
Just during all this time the forum was active, I was always in touch with the Microsoft team so they could monitor the impact that the forum we had created. I hope the forum has served you as a sample of what an official Power BI forum could be in Spanish.
An ordinary day comes to me excellent news – the Microsoft team has a new system that can be implemented on the official Power BI forum/community (which was only in English) to be able to make syndicated content or, to put it another way, have a forum/community entirely in Spanish that could then be translated into English and the content in English could be translated into Spanish through this content syndicate system.
For the past few weeks I have been in conversations with the Microsoft team to test this system and just today this new forum/community and system have been released. You're just reading this new post from the new official Microsoft Power BI forum in Spanish 😊
This was always my goal. That the forum/community was under Microsoft's domain and is known as the official one for Power BI and I think this syndication system is the right one.
This post is simply a small personal blog that I wanted to share with everyone to give them a little more context about how we got to where we are right now.
Because of this great new effort by the Microsoft team, and to merge communities that don't compete with each other, I've decided to unsubscribe from the Powered Solutions forum to give way to this new forum in Spanish.
I want to thank all the people who registered and participated in the Spanish-based Powered Solutions forum and I hope to register and become active members of this new site.
Here are some general forum statistics in the time it was active:
700 registered members
500 themes created
2K posts posted
57 connected members at the same time was our most connected!
Again, thank you to all those who supported us throughout this time and to new members for being part of this great global Spanish Community of Power BI.
Hello! I'm starting with powerbi and I have a shower.. How can I get the accumulator out of values without them being related to a date? e.g. in one column I have a product name and in another its value in euros. I searched the internet but only found accumulated linked to a date in time using commands like calculate and filter all. Thank you!
I clarify that the values do not have a related date, I just want to make a pareto to see the products with the most value and cut in 20%...
Hello, good night. I hope you can give me a hand with a couple of consultations:
1. I do not understand why the English version is installed and the one I charged is the Spanish version. I've done the process twice and I have the same result. (I had already been using the English version, but I prefer the truth to use the Spanish version).
2. In the filters of the visualziations I do not see the filter top N, I only see the basic filter and the advanced. Is there an add-on that should be installed?
Hi Miguel how are you? I hope you're all right. I recommend Ana BisBé to make the following consultation. I'm telling you to install an evaluation version of Power BI Report Server and now I got the corresponding Key, but I don't even know how I have to upload it to license that service? Can you give me a hand or have an idea who can help me? Thank you very much and apologise for the inconvenience. Atte. Gustavo
that's a problem of contextualizing filters or rows, depending on the data model you have (we'll have to look at your fact table and your dimension tables) SUM() performs the operation only from the filter context and SUMX() from the row context.
I insist again, if your data model is correct, SUMX() should solve your problem, but if the model is not correct, then there is another drawback that you would not know how to answer only with the question posed.
Thank you very much for answering. The queries are mounted according to the following screen, I do not know if with this information will be enough, below I put the table that contains the items and sales:
Hello everyone, this is my first time in the community. Please, I would appreciate you helping me with a task I must present:
I have the following Table:
I'm trying to calculate the Square Metro (M2) of each "Store" by "Territory".
Use 2 measures:
1. M2 por Cod Local = calculate(averagex(FILTER(Fact_transacciones,Fact_transacciones[COD_LOCAL]),Fact_transacciones[M2]))
I do a Calculate, filtering the "COD_LOCAL" column. Then, to get the "M2" I use an AVERAGE because, as seen in the photo, the "M2" is the same for a store. Example: "COD_LOCAL" 81 has 196.28 M2 in each record. Using an AVERAGE would only have one un repeated value.
2. Suma M2 = sumx(FACT_TRANSACCIONES(COD_LOCAL]),[M2 by Cod Local])
Then use SUMX and the DISCTINCT function for COD_LOCAL to get the M2 from each LOCAL.
Indeed, I'm getting the right "M2" values by territory.
But.... when I want to add more territories and sum their totals from the column "Sum M2" (Total row), these do not add up correctly. (the right thing would be 2,484.58+3743.78 x 6,228.36). I realized that they do not add up correctly because making a DISCTINT in the COD_LOCAL, only considers a unique LOCAL and does not consider the fact that the same store (LOCAL) can operate in more than one "Territory".
I am wanting to learn BiPower completely from scratch, since it is a tool that I see many possibilities in my current work, where everything is shared "handcrafted" to say in some way, tables and tables and more tables of excel, that you have to join, make up, combine, etc. a work that is too laborious and that usually presents many errors to be corrected.
In my city, less in my work there are those who can teach me the use of this tool, so I signed up for the course of 4 weeks of edx.org, the truth I find something confusing and very basic and superficial, any place that they consider is really worth to learn BiPower?