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.
My doubt is this: I need to visualize the monthly and annual growth of my sales; for this, I created the calendar table and related the tables and then for the annual percentage varication I created the variables and used the "sameperiodlastyear" function, as follows:
VAR present SUM(Sales Points[NetoAntIVA])
VAR passed- CALCULATE(SUM(SalesPoints[NetoAntIVA]); PREVIOUSYEAR(Calendar[Date]))
.. and for the monthly variation I used the "previousmonth" function, like this:
VAR present [NetoAntesIVA]
VAR passed- CALCULATE([NetoAntIVA]; PREVIOUSMONTH(Calendar[Date]))
But when I'm going to integrate it into the table, the column appears blank.
If anyone can help me with that, I'd really appreciate it.
Good Afternoon I need to make a consultation I have armed a base of rainy days with the date and amount of rain according to the locality now I need to add the seasons of the year as I can make a measure or a calculated column that from the date I recognize that station of the year is
Usually that type of error is caused by installation problems. The recommendation: Uninstall the program, restart the computer and reinstall (if the program is downloaded from the Web. If it's enterprise to call IT)
Thank you for this space! I am discovering Power BI at the suggestion of a computer advisor from the company where I work and I am delighted with all its potential. I am currently following ana María Bisbé York's courses on Linkedin Learning.
Gentlemen, I have the following problem to perform the work in power -bi, I have the following table:
I need, if the value in the Type column is "New" look inside the other rows named "Porceso" that has the same value of the column "Solped" and bring the value of the column "Time" and place it in the column "add"