No video :(

PP04: Power Pivot Tutorial - 3 ways to create CALENDAR TABLES, Why Calendar Table in a Data Model?

Подписаться 30 тыс.

Просмотров 13 тыс.

50% 1

Chapters:
0:00 Introduction
0:53 Importance of Calendar Tables
4:57 Create a Calendar Table using Worksheet Formulas (Dynamic Array Functions)
17:41 Create a Calendar Table using Power Query
26:04 Automatically Create a Calendar Table inside Power Pivot Window
30:16 Integrate Calendar Table inside Data Model
34:31 Close
---------------------------------------------------------------------
To watch the full Playlist
• PP: Power Pivot Tutorial
---------------------------------------------------------------------
To watch PQB: Power Query Basics Series:
• PQB :Power Query Basics
---------------------------------------------------------------------
To watch PT: Pivot Tables Series:
• Excel Data Analysis: P...
---------------------------------------------------------------------
To download the excel files:
drive.google.c...
---------------------------------------------------------------------
To subscribe:
/ @aaaexcel
---------------------------------------------------------------------
To follow on Facebook:
/ excelispower
---------------------------------------------------------------------
To follow on linkedIn:
/ amratef

Опубликовано:

17 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 46

@anillpatel Месяц назад

Absolutely beautifully explained. This is a great video presentation for anyone who wants to learn about Calendar Tables. Thanks Amr.

@user-cz8yx7lq1e 6 месяцев назад

The sort tip helped me a lot! Very thanks!

@AAAExcel 5 месяцев назад

great, happy that you found somethig useful for you

@MUNANasher 2 месяца назад

Thanks for the great content ❤❤❤❤❤❤❤

@AAAExcel 2 месяца назад

Glad you enjoy it!

@jerrydellasala7643 2 года назад

NOTE: Using MS365 (Insider Edition) I had to add a line to omit "null" values in the imported Power Query by filtering the Weekday column. First try imported over 1M rows with most being blank at the top of the imported table in spite of it not appearing in the PQ preview. Also, in PQ when merging the two columns to create the new Quarter column, it was automatically named "Quarter.1", but could be fixed right in the formula for the new column. This was a GREAT video! Very clear, and the two notes above were just in case someone else ran into those issues (I wouldn't even call them problems as they were easily fixed and the first possibly a bug!). Thank you! I was the first to view this video, but the edit to my initial comment failed and lost it. Hope the comments help others.

@AAAExcel 2 года назад

Spot on, thank you so much for clarifying this, the blank issue was on my video, but I took it out in the edit as the video was too long, I would do a small video to explain it separately, thank you 🙏

@kishorpanara4191 2 года назад

Awesome dear and thank you so much

@AAAExcel 2 года назад

My pleasure 😇

@pedrofigueiredo6067 7 месяцев назад

Very helpfull! Thank you

@AAAExcel 7 месяцев назад

My pleasure

@eddieb8337 10 месяцев назад

Another great lesson, there is a goldmine of information in here...for sure 🙂

@AAAExcel 9 месяцев назад

Glad you think so!

@jawadahmadehssan6251 2 года назад

Thank you Amr for making our lives easier 🙏

@AAAExcel 2 года назад

My pleasure 😇

@ashishhanda1744 9 месяцев назад

You are best

@AAAExcel 4 месяца назад

thank you

@nagizadeorxan 9 месяцев назад

Thank you for great video!

@AAAExcel 4 месяца назад

most welcome

@zahoorsarbandi2982 2 года назад

Wonderful.. Each video is adding an amazing values to my professional life... Every video is creating curiosity for next video...👌👍🤝👏👏

@AAAExcel 2 года назад

Thank you so much 😊, happy that you like it

@tanvirislampulok2842 2 года назад

Boss you are a great teacher... Probably one of the best teacher i have ever have... But i have a request to you...can you please some video with proper guidelines how to be a data/financial analyst with excel and mention which functions i must have to know in excel if i wanna be financial analyst and make some tutorials on those?....thanks a lot for your amazing tutorials

@AAAExcel 2 года назад

Thank you so much for nice comment, regarding the financials analysis videos, I may not be able to work on the in the near future as I have very limited time these days, I may put in my plan in the future- thank you 🙏

@guillermobejardelrio5410 2 года назад

Amazing!! Many thanks

@AAAExcel 2 года назад

Thank you 🙏

@SantiagoMolero 2 года назад

Thank you!!

@AAAExcel 2 года назад

My pleasure 😇

@rashmiranjan9044 10 месяцев назад

Thanks for the nice resources. I want to know, how to change the quarter different from the 1st of January. Here we have to start the quarter on the 1st of April. Please suggest the due matter.

@AAAExcel 10 месяцев назад

this should be done inside your calendar table, you can add 2 columns in the calendar, one for the fiscal month number, and the 2nd for the fiscal quarter number, then you need to sort the month name column using the fiscal month number. the fiscal month number should be: Form 4 to 12-> deduct 3 for, and From 1 to 3 add 9. you can achieve the above using calculated columns with IF function

@rashmiranjan9044 10 месяцев назад

Thanks. I will try it

@StefanoVerugi 2 года назад

gold

@AAAExcel 2 года назад

😊😊 thank you

@TheJujuica 3 месяца назад

Does the automatic calendar table created from the PP updates itself when you add dates? or do you have to update it by hand?

@AAAExcel 3 месяца назад

You have to update it manually

@sabeelahmed1157 7 месяцев назад

Instead of CEILING.MATH, will it work with ROUNDUP formula?

@AAAExcel 5 месяцев назад

it will work

@sabeelahmed1157 5 месяцев назад

@@AAAExcel Thank you. Your way of teaching is amazing.

@mufycw Год назад

HI, If there are multiple columns with date in the data file and when you will click add date calendar then based on which column power pivot will create a date calendar?

@AAAExcel 11 месяцев назад

It will all check all columns containing dates in your model and fetch the oldest and earliest

@mufycw 8 месяцев назад

@@AAAExcelI have 4 columns with the date data, I understood it will check all the four columns date and create oldest and earliest but the date calendar will create only one date column. Now in pivot I want to choose date from any one column out of 4 so how will I do that because usually the date column is taken from date calendar table. How date column in calendar table will know I want to fetch data based on which date column out of 4 Thanks

@singhalmonica 2 года назад

Sir thx for show all methods, but pls guide what if my data not from 1jan somewhere starts from june. Power pivot shows dates from jan. How can i get rid from unwanted dates.

@AAAExcel 2 года назад

Filter out empty dates , thank you 🙏