Explore the use case of NATURALINNERJOIN DAX Function in Power BI

Подписаться 6 тыс.

50% 1

In the 1st video, I explained how the NATURALINNERJOIN function works. (link in comments).
In this video, we will go through a real-time use case of this function to understand where this function can be used.
We'll also highlight just how crucial it is to have a well-organized data model for this function to work its best. By the end of this video, you'll be a NATURALINNERJOIN pro, ready to use this nifty feature to turbocharge your data projects. Don't miss out on this chance to become a Power BI superstar with NATURALINNERJOIN!
Enjoy and share, and leave your valuable and constructive feedback.
Make sure to hit the subscribe button to stay up to date with the upcoming videos on Power BI - / @powerbihowto
Link to the 1st video to learn about the basics of NATURALINNERJOIN function: • Unleash the Magic of N...
🌏: perytus.com/
✍: perytus.com/blog/
📞: perytus.com/contact/
0:00 Introduction
1:20 Problem Statement
4:46 Data Modeling is the king
10:23 Let's use NATURALINNERJOIN function for our measure
20:36 Visualize our measures
25:38 Final thoughts and question for you
Download the pbix file here: tinyurl.com/3sw5eyer
#powerbideveloper #businessintelligence #bi #perytus #decipheryourdata #powerbipro #powerbideveloper #dax #fieldparameters #calculationgroups #learnpowerbi #howtopowerbi #powerbitraining #powerbiforbeginners #dataanalysis #microsoftpowerbi #microsoftpowerbidataanalysis #visualinteraction #visualizaton #disconnectedtables #datamodeling #naturalinnerjoin

Наука

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

4 авг 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 4

@balramprakash2430 9 месяцев назад

Great use case..

@PowerBIHowTo 9 месяцев назад

Thanks a lot! Glad you find it useful. Cheers!

@jjohn108 9 месяцев назад

Amazing use case of Natural Inner Join. Another way would be to use TREATAS fx as this does not need a direct relationship with Tbl A, B or C. Even if you create a internediate virtual table, using TREATAS & dimension table columns like dimyear, dimparts, dimcars you can maintain lineage. Im thinking that it would work in this case.

@PowerBIHowTo 9 месяцев назад

Hi there, Thanks for the feedback. Yes, TREATAS can be used as well. Appreciate the response. Maybe I will do the performance test using the both and see what works best. Best!