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.
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
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.
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 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 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.
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
![[#2024MAMA] G-DRAGON - 무제(Untitled, 2014)+POWER+HOME SWEET HOME+뱅뱅뱅+FANTASTIC BABY | Mnet 241123 방송](http://i.ytimg.com/vi/Ox29z5Nf1Uk/mqdefault.jpg)
![Advanced DAX [Full Course]](/img/n.gif)
Dude! This is SO INFORMATIVE! Thank you for elavating the community!
Davin Knight ..... more like a Dark Knight of Power BI ... awesome stuff
THANKS. IT'S HELPFUL
Glad it helped!
i want the same dataset, from where i can get this?
Thank you so much, great video
Thanks for watching!
Just working through this as an exercise. Good stuff.
Glad to hear it!
That’s was great
Can powerbi attach daily target of store to staff as they show fingerprint as defined shifts thanks
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
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. 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! 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!
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 tell me if we can do Power BI Adhoc Analytics
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!
wow, thanks for your sharing, really helpful to me
Glad to help!
Awesome thank you!
Can you please share the file with us so that we can also practice? Thanks
Interesting. Can totally consume this.
can you please share all datasets you have used
Very helpful content.....please continue making more of such videos.
Thanks for sharing! 👍
Thank you. Its helpful.
Glad it was helpful!
Good scenarios
Excellent tutorial, Thanks Devin 👍👍👍
Very Nice thank you so much sir
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.
Nice explanation
Can you share the data file the above videos?
where I can find the exercise file ?
Please can you share me the demo file to practice
Excellent!
Can I have the file used in this? Thanks
Great video but can someone save up and get Devin a mic?
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
Awwwmayzing presentation
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.
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!
Nice video 🥰🌹💞
Thanks
Awesome!!
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
Can you send me datasets??
19:15
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.