An interesting video from Oz du Soleil (Excel On Fire) where he explain how to use the Text.Select() Power Query function to keep only capitol letters from a list of full names.
Blog à destination des utilisateurs des applications de la suite Microsoft Office et de Power BI
jeudi 29 novembre 2018
mercredi 28 novembre 2018
Paginated Reports in Power BI with Chris Finlan
Chris Finlan is joining Adam and Patrick (Guy in a cube) to talk about Paginated reports in Power BI and gives us a look at what is to come for the future.
#powerbi
#powerbi
lundi 19 novembre 2018
Créer et utiliser des rapports d'analyse avec Power BI, un parcours d'apprentissage sur Microsoft Learn
Voici un parcours d'apprentissage à l'attention des personnes qui souhaites découvrir rapidement Power BI.
Ce parcours d'une durée de deux (02) heures est constitué de deux modules (02) avec lesquels vous allez d'abord découvrir Power BI puis apprendre à créer et partager un rapport avec cet outil.
Le premier module, intitulé "Bien démarrer avec Power BI", permet de découvrir Power BI, notamment ses composants et comment ils fonctionnent conjointement.
Le second module, intitulé "Créer et partager son premier rapport Power BI", vous guidera dans l'utilisation de Power BI Desktop pour accéder aux données, créer des éléments visuels et créer un rapport que vous pourrez partager avec d’autres personnes.
Et bien sûr, à l'achèvement de chaque module et parcours, vous obtenez un badge 😊
Si vous êtes prêt alors go "Créer et utiliser des rapports d'analyse avec Power BI"
Pour en savoir plus sur :
- Microsoft Learn, je vous propose cet article "Mircosoft Learn, la nouvelle plateforme d'apprentissage pratique de Microsoft"
- Power BI, rendez-vous sur la page "Un décisionnel inégalé"
dimanche 18 novembre 2018
Microsoft Learn, la nouvelle plateforme d'apprentissage pratique de Microsoft
Microsoft Learn est une plateforme en ligne gratuite qui propose une nouvelle approche de la formation.
Cette plateforme a pour objectif de vous permettre de maîtriser les concepts de base à votre rythme et selon votre emploi du temps. Selon Microsoft, cette approche est plus gratifiante et aide à atteindre ses objectifs plus rapidement. Avec Microsoft Learn vous allez pouvoir gagner des points, passer de niveaux et gagner en productivité.
Pour découvrir par vous même voici le lien : Microsoft Learn.
Un peu plus de détails
Les formations proposées tournent autour de cinq (05) produits qui sont :
Azure, PowerApps, Dynamics 365, Flow et Power BI.
Pour chacun des produits, des enseignements sont proposées sous forme de parcours et de modules d'apprentissage. Un module est un cours d’apprentissage individuel et un parcours d’apprentissage est une série de modules connexes (entre 02 et 08) qui créent ensemble un cours complet sur un sujet plus vaste.
Les parcours d'apprentissage
Au moment où je rédige cet article, 19 parcours d'apprentissages sont proposés dont :
- 13 sur Azure
- 02 sur PowerApps
- 02 sur Dynamics 365
- 01 sur Flow
- 01 sur Power BI
Pour plus d'information :
- Microsoft Learn (en anglais par Lee Stott)
- What is Microsoft Learn? (en anglais)
mercredi 14 novembre 2018
Power BI Desktop - November 2018 Updates
Ce mardi 13 novembre 2018 a été très riche en nouveautés pour Power BI Desktop dont voici un récapitulatif.
- Rapports
- Développer & Réduire les en-têtes de ligne dans un visuel Matrix
- Copier & coller des visuels entre des fichiers PBI Desktop
- Mise à jour de l'expérience de filtrage (Preview)
- Améliorer l'accessibilité des rapports
- Analytics
- Saturation des couleurs sur les visuels mis à niveau pour utiliser la mise en forme conditionnelle
- Questions connexes dans l'explorateur Q&A
- Modélisation
- Nouvelle vue de modélisation (aperçu)
- Modèles composites maintenant généralement disponibles
- Modélisation des améliorations d'accessibilité
- Nouvelles fonctions DAX
- Argument facultatif "DrilldownFilter" pour la fonction RollupAddIsSubtotal
- Fonction NonVisual
- Fonction IsInScope
- Visuels personnalisés
- Calendar par MAQ Software
- Rating par MAQ Software
- HourGlass par MAQ Software
- Prévision à l'aide de plusieurs modèles par MAQ Software
- Arbre de graphiques de secteur
- Connectivité des données
- Connecteur Azure DevOps Server
- Prise en charge des paramètres de page de début et de fin pour le connecteur PDF
- Amélioration du connecteur Azure Consumption Insights
jeudi 8 novembre 2018
Many Power BI updates on this November 7th, 2018
Yesterday
was a rich day in announcements of Power BI updates and here is a brief recap.
Power BI
delivers dataflows, enterprise reporting, and major updates to Power BI Desktop.
https://powerbi.microsoft.com/en-us/blog/power-bi-delivers-dataflows-enterprise-reporting-and-major-updates-to-power-bi-desktop/
https://powerbi.microsoft.com/en-us/blog/power-bi-delivers-dataflows-enterprise-reporting-and-major-updates-to-power-bi-desktop/
Introducing:
Power BI data prep with dataflows.
https://powerbi.microsoft.com/en-us/blog/introducing-power-bi-data-prep-wtih-dataflows/
https://powerbi.microsoft.com/en-us/blog/introducing-power-bi-data-prep-wtih-dataflows/
Public
Preview of Paginated Reports in Power BI Premium Now Available.
https://powerbi.microsoft.com/en-us/blog/public-preview-of-paginated-reports-in-power-bi-premium-now-available/
https://powerbi.microsoft.com/en-us/blog/public-preview-of-paginated-reports-in-power-bi-premium-now-available/
Power BI
Paginated Reports also available in Power BI Mobile Apps (preview)
https://powerbi.microsoft.com/en-us/blog/power-bi-paginated-reports-also-available-in-power-bi-mobile-apps-preview/
https://powerbi.microsoft.com/en-us/blog/power-bi-paginated-reports-also-available-in-power-bi-mobile-apps-preview/
Paginated
report metrics and dataflow metrics now available in Premium Capacity Metrics
app.
https://powerbi.microsoft.com/en-us/blog/paginated-report-metrics-and-dataflow-metrics-now-available-in-premium-capacity-metrics-app/
https://powerbi.microsoft.com/en-us/blog/paginated-report-metrics-and-dataflow-metrics-now-available-in-premium-capacity-metrics-app/
mardi 6 novembre 2018
Power BI in a month, October 2018
October 2018 roundup, a list of 84, posts and videos about Power BI.
C# Corner
- Create Event Calendar In Power BI (by : C# Corner)
In this article, Dhruvin teachs us how we can create Event Calendar within Power BI
https://www.c-sharpcorner.com/article/create-event-calendar-in-power-bi/
Chris Webb's BI Blog
- A Function To Generate The M Code For A Table Type (by : Chris Webb's BI Blog)
M function that takes a table and returns the text for the M code that is needed to define a table type
https://blog.crossjoin.co.uk/2018/10/03/function-m-table-type/
- [Hors-série] Modern Workplace Conference Paris (by : Club Power BI)
Découvrez les 10 questions Power BI posées par des néophytes
https://www.youtube.com/watch?v=CTdk_r1Gadk - [Aix-en-Provence] Power BI et la cartographie (by : Club Power BI)
Nouveautés du mois d'octobre, la cartographie et retour d'expérience Power BI embarqué dans une application web
https://www.youtube.com/watch?v=-svqQwFOL4M
- Aggregations in Power BI - Power week 918 Power Bi Desktop update (by : Curbal)
Ruth discuss the new aggregation feature released by the Power BI team in the Power BI Desktop update of September 2018
https://www.youtube.com/watch?v=7KKcbcXFNgM - DAX Fridays! #100: One click download and sponsor me! (by : Curbal)
Ruth is celebrating the 100th DAX Fridays by sharing a link with you to all DAX Fridays and a link to sponsor the channel and help her keep going.
https://www.youtube.com/watch?v=Y645BM2WyQs - 6 productivity tips for Power Query (by : Curbal)
Discover 06 productivity tips for Power Query
https://www.youtube.com/watch?v=fPzX6WuUlHw - Data Profiling and Fuzzy Matching in Power Query | Power Week 10.18 Power BI Desktop October update (by : Curbal)
Ruth is presenting two Power Query new features, Data profiling and Fuzzy Matching.
https://www.youtube.com/watch?v=rYidpz545bU - Filter, connectors, and more | Power Week 10.18 - Power BI Desktop Update October. (by : Curbal)
Breief presentation of October 2018 Power BI Updates
https://www.youtube.com/watch?v=vx36jOOhHTE - Download Center for all Power Bi files, finally! (by : Curbal)
Here you can now download all the pbix files that I have made for you: https://curbal.com/donwload-center
https://www.youtube.com/watch?v=NzmZcuyjWB4&feature=youtu.be - DAX Fridays! #102: The DAX Editor | Power BI October 2018 Update (by : Curbal)
Ruth show us some shortcuts that the Power BI team released with the new DAX Editor
https://www.youtube.com/watch?v=z0Kj_oVmNUA - Make your Direct Queries run faster! (by : Curbal)
Discover how you could make your Direct Queries run faster!
https://www.youtube.com/watch?v=513vtuMw5bY - DAX Fridays! #103: UNICODE, UNICHAR, LEN (by : Curbal)
Follow Ruth to understand what are the UNICODE, UNICHAR en LEN DAX functions
https://www.youtube.com/watch?v=LjnWymCh_zE - Auto deploy M connectors | Power Query (by : Curbal)
In tyis viedo Ruth shows us how to auto deploy M connectors.
https://www.youtube.com/watch?v=e7ryCNalLos - #curbaldidyouknow | Sharing your Power Bi tips and tricks (by : Curbal)
Ruth invite us to use this the #curbaldidyoukonw hash tag to let her know when you want to share with her and the community a tips ot tricks on PBI, PQ and DAX
https://www.youtube.com/watch?v=MgdglM1vVww - Version control for Power BI files (by : Curbal)
In this video Ruth shows us how to do version control with Power BI files, or at least, one way to do it
https://www.youtube.com/watch?v=i3s9isKKdDs
- Finding mismatched headers and creating a conversion table – Bonus Exercise – Chapter 4 – #PowerQuery Book (by : Datachant)
Discover a bonus exercice from Gil new Power Query Book
https://datachant.com/2018/10/26/finding-mismatched-headers-and-creating-a-conversion-table-bonus-exercise-chapter-4-powerquery-book/?mc_cid=1761211327&mc_eid=0b1f0f9849
- Key Elements to Advanced Power BI Solutions - Free Training Workshop (by : Enterprise DNA)
Sam will be reviewing a number of techniques specifically around developing high quality reporting solutions in Power BI
https://www.youtube.com/watch?v=nH5CnjZjLMA - Automated & Dynamic Financial Reporting w/Power BI (by : Enterprise DNA)
Make your financial reports automated and dynamics
https://www.youtube.com/watch?v=kPhGxoL59BM - Reporting Templates Expanded - Power BI Visualization Concepts (by : Enterprise DNA)
Find how to create Financial Reports Templates
https://www.youtube.com/watch?v=wSgJXGAJaz4 - Different Ways You Can Use The TOPN Function - DAX In Power BI (by : Enterprise DNA)
In this tutorial Sam dives into a number of ways you can use the TOPN function inside Power BI
https://www.youtube.com/watch?v=hEUbzIcCp5w - When And How To Use The EARLIER Function In Power BI - DAX Concepts (by : Enterprise DNA)
In this tutorial Sam dives into one of the more advanced functions in the entire DAX language. EARLIER is a relatively difficult function to grasp
https://www.youtube.com/watch?v=62_H3Bxu9ZM - Predicting Future Results in Power BI - Enterprise DNA Webinar Series (by : Enterprise DNA)
Enterprise DNA Webinar
https://www.youtube.com/watch?v=8a8khhZ3l7E
Excelerator BI
- Visually Appealing Power BI Reports (by : Excelerator BI)
Matt presents 3 ways you can improve the visual appeal of your reports
https://exceleratorbi.com.au/visually-appealing-power-bi-reports/ - Data Profiling in Power BI (by : Excelerator BI)
Discover with Matt this new Power Query feature that comes with the October 2018 Power BI updates
https://exceleratorbi.com.au/data-profiling-in-power-bi/ - Create a Power BI Slicer Panel (by : Excelerator BI)
Discover with Matt how you can create a collapsible slicer pane that you can show and hide on demand
https://exceleratorbi.com.au/create-a-power-bi-slicer-panel/ - When to Use SUM() vs SUMX() (by : Excelerator BI)
This is an update of a three yers old article and on of the most read on Matt blog
https://exceleratorbi.com.au/use-sum-vs-sumx/
Excelguru
- Nuthin’ ain’t nuthin’ in Power Query (by : Excelguru)
Discover the difference between 'Null' and 'Blank' and why this is important in Power Query
https://www.excelguru.ca/blog/2018/10/04/nuthin-aint-nuthin-in-power-query/ - Analyzing text with Power Query and Excel (by : Excelguru)
Discover some ideas how Power Query can be used for analyzing text that is unstructured.
https://www.excelguru.ca/blog/2018/10/17/analyzing-text-with-power-query-and-excel/
Guy in a Cube
- Power BI Cheat Sheet, Power Query in MS Flow, Home and more... (October 1, 2018) (by : Guy in a Cube)
Comments on posts and articles published during the month of september 2018
https://www.youtube.com/watch?v=j13k3Somi2Y - Power BI Minesweeper, Visual reference, World tour and more... (October 8, 2018) (by : Guy in a Cube)
Comments on posts and articles published during the 1rst week of october 2018
https://www.youtube.com/watch?v=8OUvsyUJPsM - Mashup Engine Query Monitor for Power BI Refresh (by : Guy in a Cube)
Patrick introduces the Mashup Engine Query Monitor for Power BI Refresh. This is the MEQM! A report that can be useful to see SQL Server queries that Power BI issues during refresh.
https://www.youtube.com/watch?v=1_0B_ZN2sig - Design Power BI reports, Data Warehouse updates and more... (October 15, 2018) (by : Guy in a Cube)
Preview week Roundup
https://www.youtube.com/watch?v=yUZkqlfmI-Y - How to use the Power BI Aggregations Feature (by : Guy in a Cube)
In this video, Christian Wade will show you the clicks to get to the clicky clicky draggy droppy awesomeness when working with big data, or even massive data
https://www.youtube.com/watch?v=RdHSo43LkQg - Case of the Broken Power BI Incremental Refresh (by : Guy in a Cube)
In this video, Patrick looks at a scenario where Power BI incremental refresh was broken. He then looks at a way to get Power BI incremental refresh working properly.
https://www.youtube.com/watch?v=RnrCKn5ykCc - Microsoft R, Data Science and Power BI (by : Guy in a Cube)
Microsoft R, Data Science and Power BI
https://www.youtube.com/watch?v=yj3rZTwJZaA - Fuzzy match / merging in Power BI Desktop (October 2018) (by : Guy in a Cube)
Take a look with Patrick at the new fuzzy match / merging option within the October 2018 version of Power BI Desktop an incredibly powerful feature when it comes to data matching that can be adjusted to meet your needs
https://www.youtube.com/watch?v=I65YCrJWliw - #BIPowerHour, Tips, Slicer pane, Power BI Desktop and Gateway updates, more... (October 29, 2018) (by : Guy in a Cube)
Roundup of intersting posts catched by Adam
https://www.youtube.com/watch?v=HAhksUFmhWE - Power BI Tutorial: How to Sign up (by : Guy in a Cube)
In this video, Adam shows us how to get started using Power BI
https://www.youtube.com/watch?v=WyRO5hTxEUU
How To Excel
- Importing and Exporting Data from SharePoint and Excel (by : How To Excel)
How to import Data from a SharePoint List to an Excel Table using Power Query
https://www.howtoexcel.org/tutorials/sharepoint-and-excel/
Microsoft Ignite
- Microsoft Power BI Premium: Building enterprise-grade BI models for big data - BRK3107 (by : Microsoft Ignite)
Learn how to use Power BI Premium to create semantic models that are reused throughout large, enterprise organizations
https://www.youtube.com/watch?v=FIlKTItGpDo
Microsoft Power BI Blog and YouTube Channel
- Power BI Developer community September update (by : Microsoft Power BI Blog)
This blog post covers the latest updates for Power BI Developers community
https://powerbi.microsoft.com/fr-fr/blog/power-bi-developer-community-september-update-2018/ - Power BI Desktop October 2018 Feature Summary (by : Microsoft Power BI Blog)
Discover new features and improvement for the October 2018
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-october-2018-feature-summary/ - On-premises data gateway October update is now available (by : Microsoft Power BI Blog)
October updates for On-premises data gateway
https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-october-update-is-now-available-2/ - Announcing General Availability of Custom and Certified Connectors for Power BI (by : Microsoft Power BI Blog)
Announcement that Custom and Certified Connectors in Power BI are now generally available
https://powerbi.microsoft.com/en-us/blog/announcing-general-availability-of-custom-and-certified-connectors-for-power-bi/ - Creative DAX solutions by Philip Seamark (by : Microsoft Power BI Youtube)
The webinar will explore some unusual and creative scenarios that you may not have thought of as feasible
https://www.youtube.com/watch?v=UzUMxy9GtAE - A look the Difinity conference with Leila Etaati (by : Microsoft Power BI Youtube)
Leila speeking about the "Difinity conference"
https://www.youtube.com/watch?v=e4Jw51hR8V8 - How to use Power Query and M to Create a Calendar Tables with Tristan Malherbe (by : Microsoft Power BI Youtube)
Tristan will deliver a webinar on how to build from the scratch a proper calendar table using Power Query and M language
https://www.youtube.com/watch?v=Ifi07EpRY4g - October 2018 Power BI Desktop Updates (by : Microsoft Power BI Youtube)
This month Amanda splited the hall video in individual ones (one bu section) and created a playlist
https://www.youtube.com/playlist?list=PL1N57mwBHtN1QB88J7UC5zQ-yIpjrcuW7 - Build Impactful Financial Dashboards Using Microsoft Power BI with Avi Singh (by : Microsoft Power BI Youtube)
In this video, Avi Singh, will show you how to build a impactful financial Dashboard
https://www.youtube.com/watch?v=1WQ2cayxjTo - Q&A and best practices managing Power BI Premium capacities with the Power BI Team (by : Microsoft Power BI Youtube)
Join Josh Caplan Group Program Manager on the Power BI team, as he discusses his plans for Power BI Premium
https://www.youtube.com/watch?v=YLhvGQ7C2m0
PhantomDB
- Keeping Big Data Big with Aggregations (by : PhantomDB)
Discover how to use aggregations approch to keep Big Data big.
https://phantomdb.com/2018/10/21/keeping-big-data-big-with-aggregations/
PowerBIPro
- Power BI Rank Within a Group Using the RANKX Function #Q&A (by : PowerBIPro)
Create a ranking chart, using the RANKX Function to make it super-easy to show Ranking within a Group in Power BI
https://www.youtube.com/watch?v=3u0WJFKxGJk - Traditional BI vs. Agile Power BI Talk (by : PowerBIPro)
A talk about dowinf Agile BI using Power BI with three guests
https://www.youtube.com/watch?v=LyVgpBW5Rcw - From Just an Accountant to Leading the Power BI Revolution on a Global Scale (by : PowerBIPro)
How do you go from being just another accountant in a company to someone who is leading Power BI transformation on a global scale?
https://www.youtube.com/watch?v=wASbVfhaEN8 - Power BI Data Modeling Challenge: Rolling Over Weekend Sales to Weekday (by : PowerBIPro)
In this video we tackle a Power BI Data Modeling Challenge to rollover weekend sales to Weekday.
https://www.youtube.com/watch?v=IwxwLlArFyY - Real Power BI with Lisa Randall (by : PowerBIPro)
Talk about Power BI with Lisa Randall
https://www.youtube.com/watch?v=rxRpXEwASdM - How a Power BI Side-Project Can Lead to Big Success! Feat. Barry Kresch (by : PowerBIPro)
Watch this video and learn how Barry Kresch, a Marketing and Media Research Consultant by profession, took his passion for electric vehicles and created a Power BI Side Project that may help shape its future
https://www.youtube.com/watch?v=2hLGKsVKpM0 - Power BI October 2018 Update (Monthly Update Highlights!) (by : PowerBIPro)
Avi's top 5 new features of the Power BI Desktop October 2018.
https://www.youtube.com/watch?v=PQgJs_SLYVo - From Lotus 1-2-3 to Mega Power BI Projects (feat. Michael Stanton) (by : PowerBIPro)
This powerful interview will push all your doubts in learning Power BI aside.
https://www.youtube.com/watch?v=6lvXC58zSDU - How to Create Power BI TOP N Report (Power BI Top 10 / Top N Filter) (by : PowerBIPro)
Avi shows us how we can create a Power BI TOP N Report, using a Top 10 or Top N Filter. As a bonus he also compares this with another approach using the DAX TOPN Function.
https://www.youtube.com/watch?v=4N-KocuYyNU
PowerPivot(pro)
- Comparing Rows in Power Query Part 1 (by : PowerPivot(pro))
Use Power Query to calculate the difference between one row and the previous row in a robust and refreshable way
https://powerpivotpro.com/2018/10/comparing-rows-in-power-query-part-1/ - So, You’re Getting a Data Warehouse for Power BI… (by : PowerPivot(pro))
Discover suggestion for aligning a data warehouse with Power BI
https://powerpivotpro.com/2018/10/so-youre-getting-a-data-warehouse-for-power-bi/ - Comparing Rows in Power Query Part 2 (by : PowerPivot(pro))
Follow the second part on using Power Query to calculate the difference between one row and previous row in a robust and refreshable way
https://powerpivotpro.com/2018/10/comparing-rows-in-power-query-part-2/ - Sourcing candidates and training a team on the Microsoft Data Platform (by : PowerPivot(pro))
General discusion
https://powerpivotpro.com/2018/10/sourcing-candidates-and-training-a-team-on-the-microsoft-data-platform/ - Connect Power Query to Amazon Web Services (Redshift Database) (by : PowerPivot(pro))
Learn with Doug how to connect Power Query to Amazone Web Services
https://powerpivotpro.com/2018/10/connect-power-query-to-amazon-web-services-redshift-database/
RADACAD
- Christian Wade Interview at Ignite 2018 Power BI Enterprise XMLA EndPoint Aggregations Incremental L (by : RADACAD)
Interview about all the new exciting features of Power BI for enterprises, such as XMLA Endpoint, Aggregations, Composite Model, Incremental Load and many more.
https://www.youtube.com/watch?v=CL8FM2SmEks - Bhavik Merchant Interview at Ignite 2018 Power BI and Reporting Services (by : RADACAD)
The talk is about Reporting Services and paginated reports in Power BI and the new plan of Power BI team for performance tuning
https://www.youtube.com/watch?v=oBkImFR-k7k - Justyna Lucznik Interview at Ignite 2018 Power BI and AI (by : RADACAD)
The interview is about AI features announced in Microsoft Ignite 2018 in Power BI Desktop, Power BI Service, and Power Query
https://www.youtube.com/watch?v=jW_kTwgIJRA - Ken Puls Interview at Ignite 2018 Thoughts on Power Query Announcements at Ignite (by : RADACAD)
Ken Puls talking about his thoughts on Power Query and Power BI announcements at Ignite 2018
https://www.youtube.com/watch?v=YykH8Z5KYFc - Mark Ginnebaugh Interview at Ignite 2018 on Microsoft Regional Director and MVP programs (by : RADACAD)
The interview is about these two programs and some of his experience at Ignite 2018
https://www.youtube.com/watch?v=Lr2hmqhG8fA - Fun with DAX – Minesweeper (by : RADACAD)
Lear how to create the Minesweeper game using DAX in Power BI
http://radacad.com/fun-with-dax-minesweeper - Quick DAX : Word count (by : RADACAD)
Discover how to use the MID function to split text down to individual words in DAX.
http://radacad.com/quick-dax-word-count - Power BI and Azure ML make them work with Power Query (by : RADACAD)
Leila show us how to use the Azure ML web service in Power BI (Power Query)
http://radacad.com/power-bi-and-azure-ml-make-them-work-with-power-query - Fuzzy Matching in Power BI and Power Query; Match based on Similarity Threshold (by : RADACAD)
Explore in details, with Reza, how the fuzzy matching works in Power BI
http://radacad.com/fuzzy-matching-in-power-bi-and-power-query-match-based-on-similarity-threshold - Find Lost Customers Using Power BI and DAX (by : RADACAD)
Learn how to use Power BI and DAX to find lost customers and new customers easily with a video at the and of the post (https://www.youtube.com/watch?v=m1uupRDWzQw)
http://radacad.com/lost-customers-dax-calculation-for-power-bi
SQL BI
- Power BI Visuals Reference V2.0 (by : SQL BI)
Release of the V2.0 of the The ultimate reference for Power BI charts and visuals.
https://www.sqlbi.com/ref/power-bi-visuals-reference/ - Displaying the Nth element in DAX (by : SQL BI)
This article describes how to create a measure displaying the name or value of an element that has a specific ranking, with different option for managing ties.
https://www.sqlbi.com/articles/displaying-nth-element-in-dax/ - Optimizing IF and SWITCH expressions using variables (by : SQL BI)
This article describes how variables should be used in DAX expressions involving IF and SWITCH statements in order to improve performance
https://www.sqlbi.com/articles/optimizing-if-and-switch-expressions-using-variables/
The BICCOUNTANT
- Find and index duplicate figures in Power BI and Power Query (by : The BICCOUNTANT)
How to find duplicate rows in a table and add a nested index to each duplicate row.
https://www.youtube.com/watch?v=cXb308NPU2M - Return all occurrences of text between delimiters in Power BI and Power Query (by : The BICCOUNTANT)
How to retrieve all occurrences of strings between in a text field
https://www.thebiccountant.com/2018/10/26/return-all-occurrences-of-text-between-delimiters-in-power-bi-and-power-query/ - Create list of accounts from NAV account schedules or COA totaling syntax (by : The BICCOUNTANT)
Imke shows us how to create a list of account numbers from the totalling syntax that you find in Dynamics NAV account schedules or chart of accounts
https://www.thebiccountant.com/2018/10/27/create-list-of-accounts-from-nav-account-schedules-totalling-power-bi-power-query/
biDezine
- 2018 October Update - Power Bi Desktop (by : biDezine)
Power BI Desktop updates for October 2018
https://www.youtube.com/watch?v=WnlO0XLdPjM
Fourmoo
- Quick Tips for Aggregations & Composite Models in Power BI (by : fourmoo)
Gilbert present some tips that he found few useful to assist you with getting up and running on the implementation of Aggregations with Composite Models in Power BI
https://www.fourmoo.com/2018/10/23/quick-tips-for-aggregations-composite-models-in-power-bi/
samedi 3 novembre 2018
Free Azure Practice Tests for MCTs
In order to help you prepare for the new role-based Azure certifications, MCTs can now receive a 100% discount on new Azure MeasureUp Practice Exams, available through Pearson VUE. This limited-time offer is available only while supplies last.
MCT Beta Exam 100% Discount Codes
We are excited to offer discount codes for 100% off all new role-based exams, as they are released in beta, while supplies last. These codes are meant for Microsoft Certified Trainers (MCTs) who are specialists in the new exams, so if you’re just getting started with the topic area, please wait for the 75% MCT exam discount (after the exams come out of beta). For a link to the new MCT beta exam codes and their associated start and end dates, look in the blue Resources section on MCT Central.
To learn about the beta exam AZ-400 that was released on October 26, 2018, check out “Are You a DevOps Engineer? Take the AZ-400 Beta Exam, and Prove You Know Your Stuff.” To find out about two new Microsoft 365 Enterprise Administrator beta exams, MS-100 and MS-101, watch the Microsoft Learning Blog in early November.
Inscription à :
Articles (Atom)