Hi Alfred, we are glad to hear that you were able to learn great and new tricks with this video. I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg - No credit card required and you will get instant access of all our courses.
How do you create a single dashboard from visualizations across multiple workspaces? I have a finance GL workspace and a Marketing workspace and now I want a dashboard that the CFO can see visualizations from both.
Dear Davin, @# pragmatic works... Is it possible to get a better quality video, please? Many places display is blurry and can't make out the code Thanks VG
Can Power BI help in comparing two months payroll by highlighting the difference in various components for employees who had different payment in both months.
Hi Riaz, getting a month over month difference is pretty easy with DAX and time intelligence. The current month payroll would simply be: Payroll = SUM('TableName'[PayrollAmount]). The prior Month Payroll would be something like: Prior Month Payroll = CALCULATE( [Payroll], DATEADD('DateTable'[DateColumn], -1, Month) ) If you want to see the difference you could then create a third measure: Month over Month Diff = [Payroll] - [Prior Month Payroll] Hope this helps!
@@PragmaticWorks thank you for your reply however, what I actually wanted to ask is that lets assume that we have two components of salary i.e. Basic and Conveyance an employee receives USD 100 and 200 respectively for these two components in the month of April and the same employee receives USD 200 and 100 respectively for the same components in the month of May. Can Power BI DAX give me the information in another table under column Basic and Conveyance as 100 and -100 for the same employee? Please note that we have more than 14,000 employees and every month I have to identify the same by looking for the variance in payroll and identifying the staff who receive different payments as compared to last month. Thank you for your help!
@@riazuddin7493 If you grasp the solution from pragmatic works, your problem would be solved surprisingly. Getting stuck of having more than 1 table inside your pbix file? let the data modelling coming to play.
Thank you so much. This is exactly the solution I was looking for. After taking the steps that you mentioned here. I come to a stage where after expanding the table I have around 2Million rows in my table and I am not sure in how many pages it has spread across. There is an API call limitation of 500 calls per day. So, while loading the data to interface thousands of rows get loaded successfully and after some time getting an error message saying API call limit got over for the day. Is there any way to work around it or If you have any Videos or Blog posts please do suggest it.
Thanks.. we are glad to hear that. I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg
I have a question, wonder if you could help… Let's say I have a filter called FRUITS, of which I have currently selected BANANA, APPLE, MANGO I have created a measure called SELECTED FRUITS, in which I take fruits selected using CONCATENATEX then I put that measure to a CARD VISUAL; result is BANANA, APPLE, MANGO. I need to change this to BANANA, APPLE AND MANGO. (Basically, I need to add string “AND” before the last item selected. For an example if I select BANANA, APPLE, MANGO, AVOCADO, then CARD-VISUAL should say BANANA, APPLE, MANGO AND AVOCADO. Can you help? Thanks
Thanks. We are glad to hear that you liked the video. I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our 7-day FREE trial: www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg - No credit card required and you will get instant access of all our courses.
![DAX Filter Context Basics [Full Course]](http://i.ytimg.com/vi/Rpa8mDH7mes/mqdefault.jpg)
![DAX Filter Context Basics [Full Course]](/img/tr.png)
![Advanced DAX [Full Course]](http://i.ytimg.com/vi/ir974t0Outs/mqdefault.jpg)
Dude! This is SO INFORMATIVE! Thank you for elavating the community!
Just working through this as an exercise. Good stuff.
Glad to hear it!
Awesome thank you!
Great Video's. I have a qn I have an API with Scroll ID. Can you explain how to use it. I mean the Code to all the API Recursively
That’s was great
Can powerbi attach daily target of store to staff as they show fingerprint as defined shifts thanks
Davin Knight ..... more like a Dark Knight of Power BI ... awesome stuff
Most of this i know, but some great tricks learnt along the way.
Impressive
Hi Alfred, we are glad to hear that you were able to learn great and new tricks with this video. I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg - No credit card required and you will get instant access of all our courses.
Just had to brag on yourself, huh; get over your self importance or just keep it to self!
Can you tell me if we can do Power BI Adhoc Analytics
i want the same dataset, from where i can get this?
Great video but can someone save up and get Devin a mic?
Please share the dataset, else all goes in vain for learners. Thanks.
Thank you so much, great video
Thanks for watching!
THANKS. IT'S HELPFUL
Glad it helped!
Can you please share the file with us so that we can also practice? Thanks
How do you create a single dashboard from visualizations across multiple workspaces? I have a finance GL workspace and a Marketing workspace and now I want a dashboard that the CFO can see visualizations from both.
Dear Davin,
@# pragmatic works...
Is it possible to get a better quality video, please?
Many places display is blurry and can't make out the code
Thanks
VG
Nice video 🥰🌹💞
Hi, nice class , i am very happy if you share me data set you used in this demo, i will more help to me to practice in practical
Hi! Where is this data set of salaries you are using? Thanks.
Hi Michael. Please, reach out to Devin (dknight@pragmaticworks.com). He will be able to share the file via email
Another great session to learn PBI. Awesome Devin!
Glad you enjoyed it!
Can Power BI help in comparing two months payroll by highlighting the difference in various components for employees who had different payment in both months.
Hi Riaz, getting a month over month difference is pretty easy with DAX and time intelligence. The current month payroll would simply be:
Payroll = SUM('TableName'[PayrollAmount]).
The prior Month Payroll would be something like:
Prior Month Payroll =
CALCULATE(
[Payroll],
DATEADD('DateTable'[DateColumn], -1, Month) )
If you want to see the difference you could then create a third measure:
Month over Month Diff = [Payroll] - [Prior Month Payroll]
Hope this helps!
@@PragmaticWorks thank you for your reply however, what I actually wanted to ask is that lets assume that we have two components of salary i.e. Basic and Conveyance an employee receives USD 100 and 200 respectively for these two components in the month of April and the same employee receives USD 200 and 100 respectively for the same components in the month of May. Can Power BI DAX give me the information in another table under column Basic and Conveyance as 100 and -100 for the same employee? Please note that we have more than 14,000 employees and every month I have to identify the same by looking for the variance in payroll and identifying the staff who receive different payments as compared to last month. Thank you for your help!
@@riazuddin7493 If you grasp the solution from pragmatic works, your problem would be solved surprisingly. Getting stuck of having more than 1 table inside your pbix file? let the data modelling coming to play.
Good scenarios
Interesting. Can totally consume this.
Please can you share me the demo file to practice
where I can find the exercise file ?
wow, thanks for your sharing, really helpful to me
Glad to help!
Can you share the data file the above videos?
Thank you so much. This is exactly the solution I was looking for. After taking the steps that you mentioned here. I come to a stage where after expanding the table I have around 2Million rows in my table and I am not sure in how many pages it has spread across. There is an API call limitation of 500 calls per day. So, while loading the data to interface thousands of rows get loaded successfully and after some time getting an error message saying API call limit got over for the day. Is there any way to work around it or If you have any Videos or Blog posts please do suggest it.
Awesome very useful information :)
Thanks.. we are glad to hear that. I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg
Can I have the file used in this? Thanks
Very Nice thank you so much sir
Very helpful content.....please continue making more of such videos.
can you please share all datasets you have used
Thanks for sharing! 👍
Can you send me datasets??
Excellent tutorial, Thanks Devin 👍👍👍
Awwwmayzing presentation
Nice explanation
19:15
Thank you. Its helpful.
Glad it was helpful!
I have a question, wonder if you could help…
Let's say I have a filter called FRUITS, of which I have currently selected BANANA, APPLE, MANGO
I have created a measure called SELECTED FRUITS, in which I take fruits selected using CONCATENATEX
then I put that measure to a CARD VISUAL; result is BANANA, APPLE, MANGO.
I need to change this to BANANA, APPLE AND MANGO. (Basically, I need to add string “AND” before the last item selected. For an example if I select BANANA, APPLE, MANGO, AVOCADO, then CARD-VISUAL should say BANANA, APPLE, MANGO AND AVOCADO.
Can you help? Thanks
Try this community.powerbi.com/t5/Desktop/Card-visual-with-multiple-selection-slicer/td-p/678090
Awesome
We are glad to help
Excellent!
Thanks
Awesome!!
Great video 👍
Thanks. We are glad to hear that you liked the video. I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our 7-day FREE trial: www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg - No credit card required and you will get instant access of all our courses.
Pragmatic Works Thanks mate. I will definitely check it out.
@@toulasantha Glad to help!
half of the presentation is blurred. Funny enough the most interesting part.
Check your internet connection. Nothing wrong with the video at all.