Power BI Modelling - Part 2 | Relationship | One to One | One to Many | Power BI Tutorial (44/50)

How to Properly Model your Power BI report
what is relationship
what is one to one relationship
what is one to many relationship
what is cross filter option in Relationship
#PowerBI #PowerBIDesktop #PowerBITutorials
✉ Business Queries / Analytics Consulting ✉ : [e-mail]
💬 For Learners Post queries and Interact 💬 : t.me/analyticsw...
Complete Playlists
Power BI Tutorials - Complete Playlist 📚📖 • How to do Power BI Ins...
Power BI Desktop Tips and Tricks 📚📖 • How to Remove Top N ro...
Power BI DAX - Complete Playlist 📚📖 • What is DAX in Power B...
Power BI Services Playlist 📚📖 • Introduction to Power ...
Power BI Project Dashboards - Power BI Realtime Projects - Playlist 📚📖 • Loan disbursement Anal...
Data Warehouse Tutorials 📚📖 • Introduction | Data Wa...
SQL Full Course | SQL Tutorial For Beginners 📚📖 • Learn SQL Complete | C...
SSAS Tutorials - SQL Server Analysis Services 📚📖 • Introduction to SQL Se...
SSIS Tutorials - SQL Server Integration Services 📚📖 • Introduction to SQL Se...
Power BI Interview Topics 📚📖 • What to Expect in Powe...
MSBI (SSIS,SSAS,SSRS) Interview Topics 📚📖 • What to Expect in MSBI...
Excel for Data Analysis 📚📖 • Analytics with Nags Yo...
Power BI + R 📚📖 • Analytics with Nags Yo...
Azure for Analytics - Complete Tutorials 📚📖 • Analytics with Nags Yo...
Catch with Nags 📚📖 • Catch Up With Nags - I...
Nags Checklist 📚📖 • 5 Things to Consider w...
Visuals with Nags 📚📖 • Visuals With Nags - Intro

[@mohdmuzammil3059]

Before starting to watch just given a hit to thumbs up 👍

[@AnalyticswithNags]

Thank you for your constant support

[@mohdmuzammil3059]

@@AnalyticswithNags u deserve

[@HariKrishna-mg3rs]

Tq so much sir ...For the Regular Updation of Videos...U r Helping A lot ,with ur Videos

[@AnalyticswithNags]

Thanks keep learning.
Share this channel with friends and colleagues

[@bharathsp5542]

Sir here instead of having both as cross filter direction u created measure so ok, but wt in case of column that contains textual data?

[@NithinKG-h7e]

Thank you so much sir. Its very helpful

[@AnalyticswithNags]

Welcome

[@ettimehra]

Thank you so much for this topic. you explained very well. i have a request please do not add the wordings atthe bottom of the screen coz its not looking good coz it hides some info .....

[@AnalyticswithNags]

You can uncheck the settings. Go to settings three dots ~ caption ~ uncheck

[@ritudahiya6223]

@ Analytics with nags. Please answer my doubt. When we are importing data from sql server to power bi, a dialogue box appear in which we have option
Data connectivity mode
1. Import
2. Direct query
What is the difference between these 2 options
@ 5:25

[@AnalyticswithNags]

You will find answer in this video
Power BI Tutorial (28/50) - What is Import Mode vs DirectQuery Mode
ua-cam.com/video/0uDOzEkLtd4/v-deo.html

[@sikansamantara9504]

Thank you so much sir for your efforts....it is really helpful for us

[@AnalyticswithNags]

It's my pleasure

[@asif1673]

Vi h h

[@asif1673]

Bh

[@asif1673]

B

[@asif1673]

G

[@saikishore1690]

Hi bro, kindly you help on my below issue i have one doubt in powerbi.. in excel sheet report viewed like divide some particular rows into groups and mentioned it in total and get total of that rows like that is it possible to shown in power BI, i'm using measures but those measures giving proper output but coming to view wise not same as excel. while grouping below example i'm getting group but if i using table view or matrix view rest groups are showing blank is it possible like excel
Ventures Total = ABS(CALCULATE(SUM(finance[amount]),
finance= " Services" ||
finance = " Partners" ||
finance = " Profiles" ||
finance = "Healthcare"||
finance = "Partnership"||
finance = "Partnership" ||
finance = " Partnerships"
))

"YTD
BUD" "YTD
ACT" B/(W) VS BUD B/(W) VS 2020

5,50,858 41,445 (5,50,858) (41,445)
1,17,623 20,609 (1,17,623) (20,609)
6,68,482 62,053 (6,68,482) (62,053)
if possible mail me your contact details [e-mail] i will contact you

[@AnalyticswithNags]

Can't able help much as we can't able to understand your question

[@peterrobinson1349]

I love it

[@AnalyticswithNags]

Thanks keep learning share this channel with friends and colleagues

[@manojpraveen5976]

Hi Sir, can i get the data for practice here?

[@AnalyticswithNags]

I used adventure works database . You can download from internet

[@asadKhan-gl1nf]

Hi,
How would we know when to use 1-1 or 1-M? Thank you

[@AnalyticswithNags]

Dimensions to fact 1 to many.
Fact acts as dimension as well then one to one