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.
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.
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
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.
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.
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.
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
![Advanced DAX: Problem, Design, Solution [Heavy Demo]](http://i.ytimg.com/vi/eKgcLcrebzI/mqdefault.jpg)
Dude! This is SO INFORMATIVE! Thank you for elavating the community!
Davin Knight ..... more like a Dark Knight of Power BI ... awesome stuff
That’s was great
Can powerbi attach daily target of store to staff as they show fingerprint as defined shifts thanks
THANKS. IT'S HELPFUL
Glad it helped!
Just working through this as an exercise. Good stuff.
Glad to hear it!
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
Another great session to learn PBI. Awesome Devin!
Glad you enjoyed it!
Can you tell me if we can do Power BI Adhoc Analytics
i want the same dataset, from where i can get this?
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
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
Thank you so much, great video
Thanks for watching!
Interesting. Can totally consume this.
wow, thanks for your sharing, really helpful to me
Glad to help!
Excellent tutorial, Thanks Devin 👍👍👍
Good scenarios
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.
Very helpful content.....please continue making more of such videos.
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!
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 you please share all datasets you have used
Thanks for sharing! 👍
Can you please share the file with us so that we can also practice? Thanks
Nice explanation
Thank you. Its helpful.
Glad it was helpful!
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.
Very Nice thank you so much sir
where I can find the exercise file ?
Excellent!
Can you share the data file the above videos?
Please can you share me the demo file to practice
Great video but can someone save up and get Devin a mic?
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!
Can I have the file used in this? Thanks
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.
Thanks
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
Awesome thank you!
Awesome!!
Awwwmayzing presentation
Nice video 🥰🌹💞
Awesome
We are glad to help
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
19:15
Can you send me datasets??
Please share the dataset, else all goes in vain for learners. Thanks.
half of the presentation is blurred. Funny enough the most interesting part.
Check your internet connection. Nothing wrong with the video at all.