Dynamic Attendance Sheet using Power Pivot
Вставка
- Опубліковано 19 лют 2023
- #AttendanceSheet #PowerPivot
Hello Friends,
In this video, you will learn how to create a Dynamic Attendance Sheet Using Power Pivot. This is ready to use template. In this tutorial, we have explained step by step data preparation, Table creation, Adding data to the Power Pivot Data model, creating Calculated columns and Measures using DAX, Creating Pivot table and Slicers and finally adding conditional formatting.
Download the practice file from the below link:
www.pk-anexcelexpert.com/dyna...
Learn Step by Step Pivot table:
www.pk-anexcelexpert.com/pivo...
Download the Free Project Management Dashboard
www.pk-anexcelexpert.com/exce...
See our Power BI Dashboard videos:
• Power BI Tutorial
Learn and download our interactive Excel dashboards free of cost-
• Excel Dashboards
Download the Calendar Control in VBA from below link
www.pk-anexcelexpert.com/full...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcelexpert.com/prod...
See our Excel Products:
www.pk-anexcelexpert.com/prod...
Visit to learn more:
Chart and Visualizations: www.pk-anexcelexpert.com/cate...
VBA Course: www.pk-anexcelexpert.com/vba/
Download useful Templates: www.pk-anexcelexpert.com/cate...
Dashboards: www.pk-anexcelexpert.com/exce...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
WWW.PK-AnExcelExpert.com
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/AAAAAE2OnviiEk5...
Pinterest:
/ pkanexcelexpert
LinkedIn:
/ pk-anexcelexpert
Instagram:
/ pkanexcelexpert
Visit our Amazon Store
www.amazon.in/shop/pkanexcele...
Super ❤
Thanks 🔥
I am saying these words to Shri.P K should be given great honorary award for being generous to share his files to the entire world. Sir, I touch your feet and convey my thanks sir. Long Happy Life for you sir. Thank you very much sir.
Thanks a ton
First and foremost, I want to express my gratitude for this fantastic explanation. Among the various resources I've come across, this one truly shines.🙂🙂🙂
That said, there's a specific feature I'd love to see added without losing the valuable history aspect. I regularly work with temporary staff, and it would be incredibly useful if we could automate the removal of employees from the upcoming schedule once their employment end date has passed.
Here's the catch: while adding this feature, it's vital to retain the historical data. It's essential to keep a record of past employees and their schedules, even after their employment ends. This way, we can analyze trends, track past performance, and maintain a comprehensive record of our workforce over time.
Is there any chance of incorporating this auto-removal feature without compromising the historical data? It would be a game-changer for professionals like me who need to manage changing staffing requirements while preserving valuable historical insights. Thanks once again for this outstanding resource!
Your video tutorial is really very effective, especially for me. Best wishes and love from DHAKA. ❤
Many many thanks
Wonderful congratulations from Venezuela
Thanks for all your valuable feedback🙏
Very good morning sir this is very nice
Thanks and welcome
Cool!
Thanks
Thanks
Welcome
Excellent, Your Videos are always Unique......
Can we get/download this template.?
Download link has been given in video's description box or visit our website WWW.PK-AnExcelExpert.Com
Can I do the same thing by using pivot table instead of power pivot?
Sir, how do we fit that data in pivot charts & even in ppt at single page ? Please make a video or share the link
Sir please create sales receipt and print the the invoice and save the item data and ledger of party
will try to create soon
Thank You for this Video, Sir 🙏
In My Power Pivot, I did not get:
(i) SELECTEDVALUE
(ii) ISINSCOPE
I have a Personal Office 365 Subscription.
Are these 2 functions not available in My Excel Version? Please advise.
Is there an alternate . . so that I can prepare the same dashboard?
Thank You!
Best Wishes!
SELECTEDVALUE and ISINSCOPE are DAX functions that are available in Power Pivot for Excel 2013 and later versions, including Office 365 subscriptions. However, these functions are only available in Power Pivot and not in regular Excel.
If you are not able to see these functions in your Power Pivot window, it could be because of one of the following reasons:
You are using an older version of Power Pivot: Make sure that you have the latest version of Power Pivot installed. You can check for updates by going to File > Account > Update Options > Update Now in Excel.
You have not enabled the formula bar in Power Pivot: Make sure that the formula bar is enabled in Power Pivot. You can do this by going to Power Pivot > Options > Formula Bar, and then selecting the "Show formula bar" checkbox.
If you have confirmed that you are using the latest version of Power Pivot and have enabled the formula bar, and you still cannot see SELECTEDVALUE and ISINSCOPE, then it is possible that they are not supported in your language version of Excel.
@@PKAnExcelExpert
Thank You Sir for Your response 🙏
I tried what You suggested . . still, I don't see ISINSCOPE and SELECTEDVALUE functions 😞
1. I updated My Excel.
2. The formula bar is visible in Power Pivot . . though, I could not find the way to make the formula disappear.
3. I am based in Pune, India . . I have a Paid Office 365 Subscription.
Thank You for Your Support!
Best Wishes!
@@ankursharma6157 Hi Ankur...I am also facing same problem...is it resolved for you...tx
isinscope formula not reflecting