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
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
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
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 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
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
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 ?
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 same request , if you can share the dataset for practice , this would help tremendously . I have been watching your videos for learning powerBI.
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 ..
![[UNCUT] "บอสณวัฒน์" แฉ! แหล่งซุกเงินแก๊งบอส ขยันผิดที่ไม่กี่ปีก็เข้าคุก l คนดังนั่งเคลียร์ l17ต.ค.67](http://i.ytimg.com/vi/BL56qIfXYZM/mqdefault.jpg)
u speak very simple. That is the best part along with your content......keep simplifying things......thanks a lot
Thanks and welcome
One of the best chanel to learn Power Bi thank you great content
Thank you
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
Either merge / join into single table. Your new table should have product, date, impressions, sales
Very useful. Thanks for making it easy to follow.
Awesome explanation sir ! Pretty clear explanation
Glad you liked it
Thanks good coverage of UseRelationship
Thanks keep learning
Thanks a lot sir!!
Can you please confirm if sales[Receipt no] and sales[session id] have same values.
wonderful explanation.. Very much liked your way of teaching :)
Glad to hear that
Clear explanation
Thanks
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
Active relationships is performance efficient . So go for it.
Soon will make a video on your request
Thank you for replying
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
Even you duplicate sales ( date table should be distinct of Date column) so, it wont duplicate and occupy much size
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
Not sure what’s is question
@@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
Hatsoff to you sir, It helped me in my project. Thanks a ton
Glad to hear that
Way of explaining each topic is really nice..
Could you please post the dataset link...
Will share in sometime, and will udapte the link in desc
Can you provide the data you are using?
Dear Sir, Nice explanation and Good Work. Could you please share the dataset link
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
Hi Brother.. why not taking quantity instead of Session id to see total sales quantity by sales date
We have to take quantity. It may be by mistake
@@AnalyticswithNags k and thank u for reply
@@AnalyticswithNags and one more thing is 'Tabular SSAS Cubes' is mandatory for Power Bi
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 ?
try to add datestamp in file and use batch code
Sir Please record in 1080p Quality as it is still not so clear in 720p quality
Sure
Explain is good , but it can be more improved
Thanks and welcome
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!!
Let me check
@@AnalyticswithNags same request , if you can share the dataset for practice , this would help tremendously . I have been watching your videos for learning powerBI.
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
Thanks for highlighting it. Surely will find the solution for it.
Surely will improve the recording quality and zooming option. If you are viewing in mobile, I recommend you to watch in desktop.
@Shubham Dhole Will keep this in mind and will try to upload for all the future videos and link it in desc.
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 ..
True
Add dataset please
This is for understanding. Not all videos have dataset.