Директ-ПРО // Новости Power BI. Страница 5

Why Power BI totals might seem inaccurate - SQLBI

A common question is why Power BI totals are inaccurate because they do not display the sum of individual rows. In this article, we explain the reasons why

Условное форматирование цветом

Один из любимых инструментов у пользователей #Excel - условное форматирование. В #PowerBI также присутствует условное форматирование...

How To Add A Conditional Index In Power Query

In this video, Melissa is going to give a walkthrough on her approach for Bhavya Gupta’s Power Query Challenge involving Conditional Indexing. The task is to add an index number from 1 for each ID in the table and begins in the row after the values in the date columns hit more than or equal 90. Link to the Power Query Challenge: https://bit.ly/3T9XBSJ ***** Video Details ***** 00:00 Introduction 00:57 Group By 02:43 Table.RowCount 02:56 List.PositionOf 04:54 Generic list 06:00 List.Repeat 06:40 Restricting elements 07:50 Contstruct table 09:20 Expand nested tables ***** Learning Power BI? ***** FREE COURSE - Ultimate Beginners Guide To Power BI - http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi FREE COURSE - Ultimate Beginners Guide To DAX - http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax FREE - Power BI Resources - http://www.enterprisedna.co/power-bi-resources FREE - 60 Page DAX Reference Guide Download - https://www.enterprisedna.co/dax-formula-reference-guide-download/ Enterprise DNA Membership - https://www.enterprisedna.co/membership Enterprise DNA Online - http://portal.enterprisedna.co/ Enterprise DNA Events - https://www.enterprisedna.co/enterprise-dna-events-page/ #EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #PowerQuery #PowerQueryTutorial

Introducing Cross-tenant Power BI Dataset Sharing

Our new cross-tenant dataset sharing capability is now available in public preview! This exciting capability allows customers to share their Power BI datasets with external users (consumers) in a way that allows these external users to access the datasets in their own Power BI tenant.

Maneuvering Total's Row in Table or Matrix in Power BI

In this video you'll learn to manipulate the filter context for the total's row in Table or Matrix visual using HASONEVALUE & INSCOPE functions in Power BI. ===== ONLINE COURSES ===== ✔️ Mastering DAX in Power BI - https://goodly.co.in/learn-dax-powerbi/ ✔️ Power Query Course- https://goodly.co.in/learn-power-query/ ✔️ Master Excel Step by Step- https://goodly.co.in/learn-excel/ ✔️ Business Intelligence Dashboards- https://goodly.co.in/learn-excel-dashboards/ ===== LINKS 🔗 ===== Blog 📰 - https://www.goodly.co.in/blog/ Corporate Training 👨‍🏫 - https://www.goodly.co.in/training/ Need my help on a Project 💻- https://www.goodly.co.in/consulting/ Download File - https://goodly.co.in/maneuvering-totals-row-table-matrix-power-bi/ ===== CONTACT 🌐 ===== Twitter - https://twitter.com/chandeep2786 LinkedIn - https://www.linkedin.com/in/chandeepchhabra/ Email - [email protected] ===== CHAPTERS ===== 0:00 Intro 0:18 Explanation of the Problem 1:18 Solving with HASONEVALUE Function 3:08 Checking Using Year Filter 4:03 Solving with INSCOPE Function 5:48 Deep Dive into the Query 7:58 My Courses ===== WHO AM I? ===== A lot of people think that my name is Goodly, it's NOT ;) My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI. Please browse around, you'd find a ton of interesting videos that I have created :) Cheers! - - - - - Music By: "After The Fall" Track Name: "Tears Of Gaia" Published by: Chill Out Records - Source: https://goo.gl/fh3rEJ​ Official After The Fall YouTube Channel Below https://www.youtube.com/channel/UCGQE...​ License: Creative Commons Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) Full license here: https://creativecommons.org/licenses

A Power Query feature you may not know about! - Guy in a Cube

We thought everyone knew about this Power Query capability! At the Power Platform Conference, we found that many did not. Well, we want to help make sure everyone is aware so that you can reuse your awesome Power Query work in Power BI or Excel!

How To Use COALESCE In Power Query / M

In this video, Melissa will demonstrate how to implement the Power Query/M Language operator, COALESCE, by examining two practical problems. The goal is to filter our all strings that don’t consist of two words. ***** Video Details ***** 00:00 Introduction 01:27 Example 1 04:00 Example 2 ***** Learning Power BI? ***** FREE COURSE - Ultimate Beginners Guide To Power BI - http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi FREE COURSE - Ultimate Beginners Guide To DAX - http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax FREE - Power BI Resources - http://www.enterprisedna.co/power-bi-resources FREE - 60 Page DAX Reference Guide Download - https://www.enterprisedna.co/dax-formula-reference-guide-download/ Enterprise DNA Membership - https://www.enterprisedna.co/membership Enterprise DNA Online - http://portal.enterprisedna.co/ Enterprise DNA Events - https://www.enterprisedna.co/enterprise-dna-events-page/ #EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #PowerQuery #PowerQueryTutorial

Introducing RANKX in DAX - SQLBI

RANKX is a simple function used to rank a value within a list of values. Its use is simple, but it can be a source of frustration for newbies.

Power BI Custom Visual – Chiclet Slicer

Introduction: Slicer is one of the most common and important controls for Power BI report design, which is quite helpful for many dynamics interaction. Although its operation procedure is very simple, the traditional slicer still can achieve the expected effects. However, traditional slicer has limi...

Миллионы строк в Power BI - чем пользоваться для отчётов разного объема?

Регистрация аккаунта Power BI за рубежом: http://directprobi.ru/blogs/sankcii-power-bi-uhodit-iz-rossii-chto-delat/ Наши курсы: 1) Основы Power BI: https://directprorf.ru/basics?utm_source=youtube 2) Курс "Из API - в Excel и Power BI" + готовые коннекторы: https://directprorf.ru/excel?utm_source=youtube 3) Продвинутый Power Query: https://directprorf.ru/pro?utm_source=youtube 4) Написание коннекторов в Power Query: https://directprorf.ru/connectors?utm_source=youtube Бесплатные коннекторы: https://github.com/morinad/all_connectors_pq По вопросам, связанным с курсами и коннекторами: https://t.me/alexdirect Таймкоды: 0:48 - если в отчёте до 100 000 строк 1:39 - если в отчёте до 1 миллиона строк 2:19 - если в отчёте до 10 миллионов строк 3:31 - если в отчёте до 100 миллионов строк 4:10 - работа с данными из базы данных 5:44 - если в отчёте более 100 миллионов строк 6:47 - ограничения файла в 1ГБ на тарифе Power BI Pro 7:16 - Direct Query и Live Connection 8:35 - итоги по объемам данных и инструментам Другие интересные видео: Возможности Power BI: https://youtu.be/LCxEppoM0rs Обращения к элементам в Power Query: https://youtu.be/hZi0I5RQXDc Что должен знать спец по Power BI: https://youtu.be/HIY9joipuzs Что и когда изучать в Power BI: https://youtu.be/SBz8FoTcNfQ

What's the real size of your data model in Power BI? - Guy in a Cube

From Power BI Desktop, to Task Manager, to different spots in the Power BI service – why are the sizes different? What’s going on? How can you tell what the real size is? Well, it depends! Marco Russo joined Patrick to explain.

Chris Webb's BI Blog: Diagnosing Switch-Related Performance Problems In Power BI DAX Using EvaluateAndLog

The Switch function is often a cause of performance problems in DAX. Last year a number of optimisations were made that fixed the most common issues (and as a result you should ignore older blog po…

Introducing ALLSELECTED in DAX - SQLBI

ALLSELECTED is an extremely complex function to use in DAX. In this article, we provide an introduction to ALLSELECTED and its main use cases, leaving the m

Are you thinking about your tooltips in Power BI? - Guy in a Cube

The base tooltips in Power BI are fine. But are you overusing them? Adding everything to them in your visuals? Adam gives you some things to think about with your tooltips! Create tooltips based on report pages https://docs.microsoft.com/power-bi/create-reports/desktop-tooltips?tabs=powerbi-desktop

How to use DAX to quickly create a sample table

Scenario: In the forum, an example file is often needed to assist us in describing the problem, but since privacy restrictions prevent the provision of real data, we often choose to create virtual data in Desktop and build a model to solve the problem. This avoids the ambiguity of a literal descript...

Как в Power BI добавить URL в таблицу

Как добавить ссылку для перехода на URL прямо из таблицы

Get More Productive In Power BI With These Speed Development Techniques

In this video, Sam is going to demonstrate what he thinks are the most efficient productivity techniques that can be readily applied in Power BI that can speed up your report development by up to 200-300%! He’ll tackle embedding custom backgrounds and using a totally customized theme. ***** Video Details ***** 00:00 Introduction 01:20 Embedding a background 05:40 Custom theme ***** Learning Power BI? ***** FREE COURSE - Ultimate Beginners Guide To Power BI - http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi FREE COURSE - Ultimate Beginners Guide To DAX - http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax FREE - Power BI Resources - http://www.enterprisedna.co/power-bi-resources FREE - 60 Page DAX Reference Guide Download - https://www.enterprisedna.co/dax-formula-reference-guide-download/ Enterprise DNA Membership - https://www.enterprisedna.co/membership Enterprise DNA Online - http://portal.enterprisedna.co/ Enterprise DNA Events - https://www.enterprisedna.co/enterprise-dna-events-page/ #EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DataVisualization #DataVisualizationTutorial

How To Translate Texts Using Python For Power BI

In this video, Gaelim is going to show how to perform language or texts translation using Python and pipe that over into Power BI. This is a cool technique that can make your reports a bit more interesting. ***** Video Details ***** 00:00 Introduction 00:24 Data set 01:08 Transform data 02:35 Python script 07:46 Running the code 09:19 Other languages 09:48 Applying in Power BI ***** Related Links ***** Natural Language Processing Using TextBlob - https://thinkinfi.com/natural-language-processing-using-textblob/ ***** Learning Power BI? ***** FREE COURSE - Ultimate Beginners Guide To Power BI - http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi FREE COURSE - Ultimate Beginners Guide To DAX - http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax FREE - Power BI Resources - http://www.enterprisedna.co/power-bi-resources FREE - 60 Page DAX Reference Guide Download - https://www.enterprisedna.co/dax-formula-reference-guide-download/ Enterprise DNA Membership - https://www.enterprisedna.co/membership Enterprise DNA Online - http://portal.enterprisedna.co/ Enterprise DNA Events - https://www.enterprisedna.co/enterprise-dna-events-page/ #EnterpriseDNA #PythonTutorial #PythonForPowerBI #PowerBI #PowerBIDesktop #PowerBITutorial