Power Query Calculated Columns - Dates and Logical | Everyday Office

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

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

50% 1

Power Query can create calculated information in a number of ways. In this video, we use Date Functions, simple math, and logical calculations to create two different reports from the same query.
Everyday Office is the media arm of Knack Training, a software and professional development training and consulting company headquartered in Orlando, FL. More content can be found on:
www.knacktraini...
www.knacktraini...
Check the playlists on the Everyday Office channel for more tutorials in the areas you are having the most trouble with.

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

4 окт 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@pegwinn Год назад

Just discovered PQ and asked a chatbot about adding in calculated columns to imports. It referred me to a generic search list in youtube and you were in the list. So you answered a question I didn’t even know I needed to know about. “Reference” is gonna be a game changer for me. Thanks a lot.

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

Thank you....this was a Great Video. You save me alot of time regarding my Power Query problem!

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

i think you just solved my memory hog problems. i have conditional calculated columns like you described but then i added another calculated column to sum the conditional columns. i notice that when i refresh my query, its on the calcaluated columns that add that take forever to load. 1AM and i'm excited to go back to work. subscribed.

@hernanperez912 3 года назад

Lovely explained. Nice and easy!..Bless Sir thanks.

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

Thanks a lot

@nitinshukla914 3 года назад

Hi Bro' thanx a lot. Really helpful for me to calculate remunerations on base rate. With a Big Thank U !!

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

I don't work in HR but this was amazing

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

Hello Thanks For the Same but do we have an approach where we can write an query if date is today then today or else user should have an option to choose the dates in Calendar Slicer..

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

Can you vlook up in power query. i want to filter my customer which are not in my national account list.

@meditatereflect3354 3 года назад

Hi.. can you help me resolve my formula in power query. I have on column1 date today, in the other column2 the no of days I will add if it meets the critieria in column3. so basically it adds days but I want to remove sundays when column 2 add days. Example column 1 + column2 (i.e) 3 days but not counting sunday... Thank you!