RELATED vs RELATED Table DAX in Power BI || Related Function in Power BI
ฝัง
- เผยแพร่เมื่อ 22 ก.ค. 2022
- RELATED vs RELATED Table DAX in Power BI || Related Function in Power BI
00:01 - Introduction
00:40 - Why use RELATED & RELATED TABLE
01:30 - Understand Relationship Between Tables
03:50 - Today's Query
03:50 - Today's Query
04:40 - How to write RELATED DAX
06:42 - How to write RELATED TABLE DAX
Today, we are talking about how we can use related vs related table dax functions in power bi :-
1) Related : Returns a related value from another table.
Syntax : RELATED(column)
Return type : A single value that is related to the current row.
2) RelatedTable : Evaluates a table expression in a context modified by the given filters.
Syntax of related table : RELATEDTABLE (tableName)
Return type : A table of values
You can download practice file from this link :
drive.google.com/uc?export=do...
What is Power BI ?
Power BI is a business analytics service by Microsoft. It aims to provide interactive visualizations and business intelligence capabilities with an interface simple enough for end users to create their own reports and dashboards.
PowerBI videos links are below : -
1) What is Power Bi in Hindi | Power BI Tutorial for Beginners in Hindi: • What is Power Bi in Hi...
2) Power BI Building Blocks | Power BI Tutorial for Beginners in Hindi:
• Power BI Building Bloc...
3) How to Download Power BI | Power BI Desktop को कैसे Download करे | What is Power Bi in Hindi: • How to Download Power ...
4) Import File from Excel Notepad Web to Power BI Desktop in Hindi | Power BI Desktop Tutorial in Hindi: • Import File from Excel...
5) Power BI Query Editor Tutorial in Hindi | Power BI Desktop Tutorial in Hindi: • Power BI Query Editor ...
6) Power BI Choose/Remove column in Hindi | Power BI Tutorial for Beginners in Hindi: • Power BI Choose/Remove...
7) Power BI KEEP & REMOVE Rows Hindi | Power BI Tutorial for Beginners in Hindi | Delete Row in PowerBI : • Power BI KEEP & REMOVE...
8) Power BI Split Column in Hindi | Power BI Tutorial for Beginners | How to split column in Power BI : • Power BI Split Column ...
9) How to use Group By in Power BI Hindi | Power BI Group By Option : • How to use Group By in...
10) Merge and Append Queries in Power BI in Hindi | Merge vs Append in Power Query | Power BI Tutorial : • Merge and Append Queri...
11) How to make Simple Interactive Dashboard in Power BI | Create Dashboard | Power BI Tutorial Hindi : www.youtube.com/watch?v=031pM...
12) How to Create Relationship in Power BI | Types of Relationship in Power BI | Power BI Tutorial Hindi : • How to Create Relation...
13) Power BI Import vs Direct Query Hindi | Difference Between Import vs Direct Query in Power BI : • Power BI Import vs Dir...
14) What is PBIX vs PBIT File in Power BI in Hindi | How to Save PBIX and PBIT File in Power BI : • What is PBIX vs PBIT F...
15) Calculated Column vs Calculated Measure in Power BI | Power BI DAX Formula in Hindi : • Calculated Column vs C...
16) Power BI DAX Aggregate Function in Hindi Power BI Tutorial for Beginners : • Power BI DAX Aggregate...
17) Power BI DAX Text Function in Hindi | Power BI DAX Functions Hindi | Power BI Tutorial for Beginners : • Power BI DAX Text Func...
18) Power BI DAX Logical Functions in Hindi : • Power BI DAX Logical F...
19) Power BI DAX Date Functions in Hindi : • Power BI DAX Date Func...
20) Power BI DAX Sumx and Sum function : • Power BI DAX SUMX Func...
21) Power BI GroupBy vs Summarize Function : • Power BI Group By vs S...
22) Power BI Union Intersect Except All Except Function : • Power BI Union Interse...
On youtube, only just few videos are available on How to use related and related table function in hindi.
#related #dax #powerbi
TAGS : RELATED vs RELATED TABLE DAX in POWER BI,related dax,related dax in power bi,related table dax,related table dax in power bi,related function,related function in power bi,related table function,related table function in power bi,what is power bi,power ni in hindi,power bi tutorial in hindi,power bi teachtoeach,shrinkage in bpo,teachtoeach,what is power bi
Yar mtlb mja aaya , the way of teaching and explaining for where to Use Related and RelatedTable was amazing and extraordinary , You are far way better than those English TH-cam videos where those guys are not having any sense how to make them understand.
Thankyou brother.
Lots of Love❤❤
Very Good Explanation buddy
Wow crystal clear!
Enjoyed the logic and explanation..!
Too good man
Nice explanation, it become crystal clear. Thanks a lot🤩
Finished watching
Thanks, very good explanation
Very Nice Explained Brother, Thank You.
😍 Fantastically explained bro !
Exactly. What i am looking for
Thank You
Nice
nice explanation
finished watching
cristal clear bhai
Thank you vvery much
Any time
Very well described...
Thank You Sunil
Accurate Explanation
Thank you
outstanding
Thank You
Jitne dax function apne sikhaye hai utne kafi hai kya power bi ki job milne as a fresher???
Very nice
Thanks Mustafa
Good explaination.
file link is not opening
could you please share the data again
able to understand , thanks .
Please upload file which is missing.
1. M:1 relationship --> use Related
2. 1:M relationship --> Relatedtable
Yes
sir power query me same function use hote hai fir dax me same function q use karne (please reply sir )
Have you deleted a previous video that you made on the same topic? If you have that video please share it with me.
please share dataset again, cant open this one.
data set ka download ni ho ri hai, is lia dislike kar raha hun.