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

BLANK – DAX Guide - SQLBI

BLANK: Returns a blank. https://dax.guide/blank/

Create ✅ELEGANT LISTS using DAX and the smart narrative visual in Power BI

Sometimes you want to add explanatory text in the form of lists (ex. top 3 sales people) to your visuals to add more context or increase the understanding of your report. In todays video, I will show you how to do that with the smart narrative visual and some dax. Here you can download all the pbix files: https://curbal.com/donwload-center SUBSCRIBE to learn more about Power and Excel BI! https://www.youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw?sub_confirmation=1 Our PLAYLISTS: - Join our DAX Fridays! Series: https://goo.gl/FtUWUX - Power BI dashboards for beginners: https://goo.gl/9YzyDP - Power BI Tips & Tricks: https://goo.gl/H6kUbP - Power Bi and Google Analytics: https://goo.gl/ZNsY8l ☼☼☼☼☼☼☼☼☼☼ POWER BI COURSES: Want to learn Power BI? How about you take one of our courses? Here you can find the available courses: https://curbal.com/courses-overview ☼☼☼☼☼☼☼☼☼☼ ABOUT CURBAL: Website: http://www.curbal.com Contact us: http://www.curbal.com/contact ************ MY GEAR: You often ask me what software I use to edit my videos, so I thought I let you know in the description and give you a discount code so you can get it too! COUPON: CURBAL10 Note, if you purchase the software using the link or code, I will receive a small commission and you will indirectly support my channel. Thanks in advance! ************ QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here: Linkedin ► https://goo.gl/3VW6Ky Twitter ► @curbalen, @ruthpozuelo Facebook ► https://goo.gl/bME2sB #CURBAL #SUBSCRIBE

ISFILTERED, ISCROSSFILTERED – DAX Guide - SQLBI

ISFILTERED: Returns true when there are direct filters on the specified column. https://dax.guide/isfiltered/ ISCROSSFILTERED: Returns true when the specifi

Optimising OData Refresh Performance in Power Query for Power BI and Excel - BI Insight

OData has been adopted by many software solutions and has been around for many years. Most solutions are using the OData is to serve their transactional processes. But as we know, Power BI is an analytical solution that can fetch hundreds of thousands (or millions) rows of data in a single table. So, obviously, OData … Continue reading Optimising OData Refresh Performance in Power Query for Power BI and Excel

Accumulative, conditional accumulative in Power Query

Scenario: In Power BI, we sometimes meet cumulative problem. For basic direct accumulation we could use Dax language or M language. But for conditional accumulation and group conditional accumulation, we tend to use M language. The following will be divided into three cases to gradually explore the ...

Turn ON-OFF Tooltips In Power BI - Goodly

Turn ON and OFF tooltips with a button in Power BI Reports

Sorting the Y-axis in Power BI | Yes, you need a hack for that.

Prefer to read? Check it out here: https://curbal.com/curbal-learning-portal/sort-y-axis-in-power-bi-visuals Here you can download all the pbix files: https://curbal.com/donwload-center SUBSCRIBE to learn more about Power and Excel BI! https://www.youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw?sub_confirmation=1 Our PLAYLISTS: - Join our DAX Fridays! Series: https://goo.gl/FtUWUX - Power BI dashboards for beginners: https://goo.gl/9YzyDP - Power BI Tips & Tricks: https://goo.gl/H6kUbP - Power Bi and Google Analytics: https://goo.gl/ZNsY8l ☼☼☼☼☼☼☼☼☼☼ POWER BI COURSES: Want to learn Power BI? How about you take one of our courses? Here you can find the available courses: https://curbal.com/courses-overview ☼☼☼☼☼☼☼☼☼☼ ABOUT CURBAL: Website: http://www.curbal.com Contact us: http://www.curbal.com/contact ************ MY GEAR: You often ask me what software I use to edit my videos, so I thought I let you know in the description and give you a discount code so you can get it too! COUPON: CURBAL10 Note, if you purchase the software using the link or code, I will receive a small commission and you will indirectly support my channel. Thanks in advance! ************ QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here: Linkedin ► https://goo.gl/3VW6Ky Twitter ► @curbalen, @ruthpozuelo Facebook ► https://goo.gl/bME2sB #CURBAL #SUBSCRIBE

Совместная работа в Power Query

Это фрагмент книги Гил Равив. Power Query в Excel и Power BI: сбор, объединение и преобразование данных. Предыдущий раздел                   К содержанию

RADIANS, DEGREES – DAX Guide - SQLBI

RADIANS: Converts degrees to radians. https://dax.guide/radians/ DEGREES: Converts radians into degrees. https://dax.guide/degrees/

Power BI Group RU

Обсуждаем Power BI и связанные темы FAQ & Правила: https://t.me/PBI_Rus/7 Канал: @PowerBIChannel Чат по Power Query: @PQ_ru Чат по Excel: @eh_chat Чат по MS SQL: @sqlcom Чат @PowerAutomate

How do I get my Excel users to use Power BI??? - Guy in a Cube

Lots of people use Excel and love it! But what about Power BI? Why not use both together? Patrick looks at how Excel users can take advantage of Power BI and may just start using that! Start in Excel to connect to Power BI datasets https://docs.microsoft.com/power-bi/collaborate-share/service-connect-excel-power-bi-datasets

Как показать меры в строках матрицы?

В заголовок я вынес достаточно простой вопрос, решение которого доступно в базовом функционале визуализации, но тем не менее вызывает...

Power BI Paginated Reports in a Day - 26: December 2021 Update

In this video, Peter Myers (Microsoft Most Valued Professional - Data Platform, and course developer) describes and demonstrates new capabilities and features added to #Microsoft #PowerBI paginated reports since the last update for December 2020 was recorded. For more information about the online course see: https://aka.ms/priad-online-course Follow us on Twitter - https://twitter.com/mspowerbi More questions? Try asking the Power BI Community @ https://community.powerbi.com/ #powerbi #paginatedreports #priad

TOPN товаров с помощью DAX в PowerBI

Ещё одна популярная задача, вопросы по которой часто встречаются в телеграмм-чате Power BI Group RU - подсчёт или отображение топовых...

EXPON.DIST – DAX Guide - SQLBI

EXPON.DIST: Returns the exponential distribution. https://dax.guide/expon-dist/

How Parameters work with the Power BI Paginated Visual - Guy in a Cube

Parameters for the Power BI Paginated visual can give you a lot of flexibility. Adam walks you through how to set up the parameters and breaks down what is actually happening with the values. Create and use the paginated report visual https://docs.microsoft.com/power-bi/visuals/paginated-report-visual

Power BI API - подключение и получение данных

Создадим приложение и выполним подключение к Power BI API

Working With Expanded Tables In Power BI

For today’s tutorial, we are going to take a look at Expanded Tables, which you’ll most probably have encountered while working with DAX. Expanded Tables are very tricky to work with and they must have messed up you calculations at least once if you haven’t figured out how they are working within your calculation, but they are most certainly fundamental to learn. Antriksh will help you understand how Expanded Tables can impact your calculations and the behavior of using them. ***** Video Details ***** 00:00 Introduction 00:44 Data model 01:47 No. of customers 03:17 Red sales 1 04:40 Red sales 2 05:55 Red sales 3 06:51 Base table vs Expanded table 08:59 How to verify a table expansion 13:39 Slicing categories 14:50 External filter context 18:30 Indirect filer 25:25 Verifying claims ***** 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://enterprisedna.co/power-bi-resources FREE - 60 Page DAX Reference Guide Download - https://enterprisedna.co/dax-formula-reference-guide-download/ Enterprise DNA Membership - https://enterprisedna.co/membership Enterprise DNA Online - http://portal.enterprisedna.co/ Enterprise DNA Events - https://enterprisedna.co/enterprise-dna-events-page/ #EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial