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

[@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

[@NithinKG-h7e]

Thank you so much sir. Its very helpful

[@AnalyticswithNags]

Welcome

[@bharath554-y2f]

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?

[@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

[@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

[@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

[@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
ruclips.net/video/0uDOzEkLtd4/видео.html

[@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