What is Primary Key , Foregin Key when to use it | what is single and both side direction

In Power BI, a primary key is a unique identifier that is assigned to each record in a table and distinguishes it from all other records in the same table. A primary key is typically used to establish relationships between tables and ensure data integrity within the data model.

A foreign key, on the other hand, is a field that is used to reference the primary key of another table. The foreign key establishes a relationship between two tables and allows data from the related tables to be combined and analyzed together.

Cross-filter direction refers to the direction in which a filter is applied in a relationship between two tables. There are two possible directions for cross-filtering in Power BI: "Single" and "Both".

"Single" direction means that filtering one table will only affect the data in that table and not in the related table.

"Both" direction means that filtering one table will affect both the data in that table and the data in the related table.

Cardinality refers to the number of unique values in a column of a table and the relationship between those values and the values in another column of another table. There are four types of cardinality in Power BI:

One to One (1:1)
One to Many (1:N)
Many to One (N:1)
Many to Many (N:N)
The cardinality of a relationship determines how the data from related tables will be combined and how filters will be applied between the tables.

Download link :- https://drive.google.com/file/d/1iGE_...

*********FOLLOW ON*************
Facebook :-   / excelworldofknowledge  
Twitter -   / sohandey3  
Instagram :-   / gyanontube  
Telegram :- https://t.me/Gyanontube
______________________
POWER BI
Power BI In Excel In hindi :-    • Power BI In Excel In hindi || Introdu...  
How to use Power Bi from beginner to advanced :-    • Power Bi in hindi || How to use Power...  
Power Bi में अपना काम सेव एंड रिकॉर्ड करे :-    • Power Bi in Excel in hindi || Power B...  
Power bi tutorial for beginners :-    • Power bi tutorial for beginners || De...  
Power BI dashboard :-    • Microsoft Power BI In hindi || Power ...  
Microsoft power bi in hindi :-    • Power Bi tutorial for beginner ||  Mi...  
Microsoft power bi course for free :-    • Power Bi for beginners || Power bi in...  
Delete unwanted columns in power bi :-    • power bi tutorial for beginners || De...  
Text to column in power bi for beginners :-    • Text to column in power bi for beginn...  
Power BI with New Icon in 2020 :-    • Power BI with New Icon in 2020 || ins...  
Power Bi Reference option :-    • Power Bi Reference option || how to u...  
Edit Data in power bi manually :-    • Edit Data in power bi manually || Pow...  
power bi tutorial for beginners in hindi :-    • power bi tutorial for beginners in hi...  
power bi dax tutorial for beginners :-    • power bi dax tutorial for beginners |...  
Power BI relationships between tables :-    • Power BI relationships between tables...  


Excel formula
How to use index match formula from Basic to advance :-    • index match excel || How to use index...  
How to make big formula in excel in hindi :-    • combination formula || How to make bi...  
Xlookup and Filter formula in hindi :-    • Xlookup for Free || New formulas for ...  
How to reduce excel file size :-    • compress excel file || reduce excel f...  
How to use Xlookup in excel :-    • How to use Xlookup in excel 😮 || xloo...  
xlookup formula in hindi :-    • How to use Xlookup in excel 😮 || xloo...  
array function in excel :-    • Array formula excel || array function...  
New Xlookup with Search Mode :-    • xlookup in excel in hindi || Xlookup ...  
Xmatch formula in excel in hindi :-    • Xmatch formula in excel || Xmatch for...  
how to use filter formula in excel in hindi :-    • filter formula in excel || how to use...  
Excel formulas and functions:-    • Top 10 excel formulas 😮|| excel formu...  
How to use excel unique function:-    • How to use excel unique function || E...  
Sort formula in excel :-    • Sort formula in excel || array formul...  


Pivot Table
pivot table from beginner to advanced :-    • how to use pivot table excel || pivot...  
Pivot table in hindi :-    • Pivot Table In Excel || how to use pi...  
How to use pivot table excel :-    • How to use pivot table excel || New t...  
Pivot table in hindi in excel :-    • pivot table excel from beginner to ad...  
Drill Down in Pivot table excel :-    • Drill Down in Pivot table excel || Cl...  
Pivot Graph in excel in hindi :-    • 3D Pivot Graph in excel in hindi || L...  
how to use pivot table slicer :-    • excel slicer || how to use pivot tabl...  
IF formula in Pivot table :-    • advanced pivot tables || advanced piv...  
power pivot in excel :-    • power pivot || how to use power pivot...  
how to link data in power pivot in hindi :-    • power pivot in excel || how to link d...  
how to use power pivot in excel in hindi :-    • power pivot in excel || how to use po...  

Gyan On Tube Excel