Тёмный

How to use CONCATENATE / LEFT / MID / RIGHT / LEN / SEARCH / REPLACE DAX functions in Power BI 

Fernan
Подписаться 46 тыс.
Просмотров 4,9 тыс.
50% 1

Get Demo Files here
ko-fi.com/s/40813e31d0
In this video we cover how to use the most-commonly used text transformation functions in Power BI. We also go through how to use them together in order to create some impressive result.
-
🚩 Support us to get perks such as demo files, early access and more!
/ solutionsabroad
MY FAVOURITE POWER BI BOOKS
📕 The Definitive Guide to DAX - amzn.to/3ruYs2f
📗 DAX Patterns - amzn.to/3oVgOYs
MY GEAR
🎥 Canon 4000D DSLR Camera - amzn.to/3tCqDOw
💻 Cyberpower Wyvern PC - amzn.to/3q04QOw
🪑 Infamous Gaming Chair - amzn.to/3q3iUXw
💡 LED Studio Lighting - amzn.to/3q3ftQz
🎙 Lavalier Microphone - amzn.to/3jwKutG
📺 Monitor - amzn.to/2LuHhhO
GET IN TOUCH
📺 Website - www.solutionsabroad.co.uk
📧 Email me - fernan@solutionsabroad.co.uk
🤵 LinkedIn - / solutionsabroad
📘 Facebook - / solutionsabroad
📸 Instagram - / solutions_abroad
🐤 Twitter - / abroadsolutions
🤖 Reddit - / fernanespejo
🌍 WHO IS SOLUTIONS ABROAD
Hi, my name is Fernan, the one-man band of Solutions Abroad. I work as a Data Scientist based in London, UK and have over 6 years of experience working in Business Intelligence. Solutions Abroad these days is dedicated to teaching the ins and outs of Power BI, through the power of RU-vid.
If you want to learn more, I’ve conveniently created playlists to help you find the right topic for you.
🐎 First, watch this video about how a typical Power BI workflow looks like
• Power BI from START to...
🗺 Learn DAX to extend your Power BI calculations
• Power BI DAX Basics OLD
📆 Stay up-to-date on all the features Power BI releases monthly
• Power BI Monthly Featu...
🧪 Get certified as a Microsoft Data Analyst Associate
• Power BI DA 100 Prepar...
💡 Learn Power BI Features to improve your dashboards
• Power BI Feature Highl...
📊 WHAT IS POWER BI?
Power BI is a business analytics tool by Microsoft. It creates a working environment suited for normal users, meaning tasks such as data extraction, cleansing, analysis and storytelling; these are made easily-accessible to citizen-users, and extendable for technical users. At face value it provides visually-stunning, interactive dashboards, but it’s built on top of so much more.
🔻 Get started with Power BI Desktop for FREE
powerbi.microsoft.com/en-us/d...
#PowerBI #DataAnalytics #BusinessIntelligence

Опубликовано:

 

30 июл 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 8   
@elinavinni6540
@elinavinni6540 3 года назад
Good video, very well explained! I noticed you missed the reference to the LEN formula? I guess it just returns the number of characters in the text cell
@SolutionsAbroad
@SolutionsAbroad 3 года назад
Great spot! Yes I must've mid-edited that part, but exactly, LEN just counts the number of characters in a field
@SiddhantGode-fh5lc
@SiddhantGode-fh5lc 2 месяца назад
Can We create a measure rather than a column for using concatenate?
@bettyg9661
@bettyg9661 2 года назад
very good, Thank you!
@valquiriamoura5618
@valquiriamoura5618 2 года назад
thanks for the video
@SolutionsAbroad
@SolutionsAbroad 2 года назад
You're welcome!
@computergyaninhindi6385
@computergyaninhindi6385 3 года назад
Good
@SolutionsAbroad
@SolutionsAbroad 3 года назад
Thanks
Далее
Create insightful calculations using CONCATENATEX.
12:27
Propagating filters using TREATAS in DAX
19:18
Просмотров 44 тыс.