Power BI Tutorial (19/50) - What is Role Playing Dimension or UseRelationship

[@akshaypatil8155]

u speak very simple. That is the best part along with your content......keep simplifying things......thanks a lot

[@AnalyticswithNags]

Thanks and welcome

[@pavanpoosoju3468]

One of the best chanel to learn Power Bi thank you great content

[@AnalyticswithNags]

Thank you

[@jayarampazhani9860]

Have Started to learn power bi thru your channel. To become familiar from scratch to advanced level your channel is the best one. Have one doubt. Pls explain I have two data sets , set 1 - products impression at day level Set2 - products sales at date level I need to visualise date level what is the impression and sales happened. Common field in 2 data sets are Date and product IDs. But count of unique product Ids will differ in both data set

[@AnalyticswithNags]

Either merge / join into single table. Your new table should have product, date, impressions, sales

[@jagans6409]

Thanks a lot sir!! Can you please confirm if sales[Receipt no] and sales[session id] have same values.

[@Learner-hg4hj]

Awesome explanation sir ! Pretty clear explanation

[@AnalyticswithNags]

Glad you liked it

[@moizku]

Very useful. Thanks for making it easy to follow.

[@StephanOnisick]

Thanks good coverage of UseRelationship

[@AnalyticswithNags]

Thanks keep learning

[@bharteshhirikude8810]

wonderful explanation.. Very much liked your way of teaching :)

[@AnalyticswithNags]

Glad to hear that

[@thirupathireddy6149]

Do we create a duplicate table for sales transaction table for making relationship active with the delivery date ,,, Im not mentioning to add data from source., Where it will add data size more.. Instead we can create the dupliacte of sales table with help of realtedtable function.. Let me know if we are having any issues doing in this process. Thanks

[@AnalyticswithNags]

Even you duplicate sales ( date table should be distinct of Date column) so, it wont duplicate and occupy much size

[@pallavijain3957]

Very nice video sir.....i hv learnt a lot from your videos... I work on HR data...with 2 date columns....Hire date and Resigned date Some people show relationship with both date inactive and then use ... userelationship function... Which method is correct? To keep both relationship inactive or keep only one inactive? Pl make a video on HR metrics..Turnover, absenteeism, Cumulative hire and cumulative resigned etc...it would be very helpful ... Thank you

[@AnalyticswithNags]

Active relationships is performance efficient . So go for it. Soon will make a video on your request

[@pallavijain3957]

Thank you for replying

[@chandrasekharv9581]

Clear explanation

[@AnalyticswithNags]

Thanks

[@aiinabox1260]

good video , but can i combine Orderdate by Qty and Shipdate by Qty using Role Playing dimension ?? If yes, how ?? Am using a table visual it correctly filters the above two but if I want to combine it shows Only order date by Qty . I don't want to use DAX . Please suggest

[@AnalyticswithNags]

Not sure what’s is question

[@aiinabox1260]

@@AnalyticswithNags In my table visual, I want to display both Sales amount by Order date & Sales Amount by shipment date values together using Role playing dimension. HOw to do that ?? Lets say I don't want to use USERELATIONSHIP

[@lokeshkharvi6825]

Way of explaining each topic is really nice.. Could you please post the dataset link...

[@AnalyticswithNags]

Will share in sometime, and will udapte the link in desc

[@shortdemo5531]

Can you provide the data you are using?

[@lakshmikanthparvathapuram1250]

Hi Nag, Would you mind providing the dataset for this video to practice?..I took dataset used for star schema video , However in the fact table Delivery date field is missing. kindly help. Thank you!!

[@AnalyticswithNags]

Let me check

[@mjeewani123]

@@AnalyticswithNags same request , if you can share the dataset for practice , this would help tremendously . I have been watching your videos for learning powerBI.

[@DIAcademy2405]

Hatsoff to you sir, It helped me in my project. Thanks a ton

[@AnalyticswithNags]

Glad to hear that

[@gaddesiva1549]

Hi Brother.. why not taking quantity instead of Session id to see total sales quantity by sales date

[@AnalyticswithNags]

We have to take quantity. It may be by mistake

[@gaddesiva1549]

@@AnalyticswithNags k and thank u for reply

[@gaddesiva1549]

@@AnalyticswithNags and one more thing is 'Tabular SSAS Cubes' is mandatory for Power Bi

[@nizammohideen3763]

Dear Sir, Nice explanation and Good Work. Could you please share the dataset link

[@AnalyticswithNags]

Check the description of the video. Most of the videos will have the file, if not exist you need to use the previous video files. Follow the Power BI complete playlist

[@abdulkhadershaik4738]

I have a requirement to take last 12 months data ( each month I will be getting a file for that month). How to just last 12 files if the folder has historical files too ?

[@AnalyticswithNags]

try to add datestamp in file and use batch code

[@rtoons5189]

Sir Please record in 1080p Quality as it is still not so clear in 720p quality

[@AnalyticswithNags]

Sure

[@Anilyadav-xw5bh]

Explain is good , but it can be more improved

[@AnalyticswithNags]

Thanks and welcome

[@meharazshaik8011]

Sir please use note pad when your explain and please zoom the screen we can't able to see anything even not able see table name also

[@AnalyticswithNags]

Thanks for highlighting it. Surely will find the solution for it.

[@AnalyticswithNags]

Surely will improve the recording quality and zooming option. If you are viewing in mobile, I recommend you to watch in desktop.

[@AnalyticswithNags]

@Shubham Dhole Will keep this in mind and will try to upload for all the future videos and link it in desc.

[@irfandaud7380]

This video is very confusing .... Formula should be CALCULATE(SUM('Sale&D'[QTY]),USERELATIONSHIP(DateDAX[Date],'Sale&D'[Delivery Date])) Using count , only give count of invoice value ..

[@AnalyticswithNags]

True

[@maxblack396]

Add dataset please

[@AnalyticswithNags]

This is for understanding. Not all videos have dataset.