Тёмный

Power Query - Dynamic Top N or Bottom N 🥶🦒 

BA Sensei
Подписаться 3,9 тыс.
Просмотров 1 тыс.
50% 1

In This tutorial i show you how to dynamically return either the Top N or Bottom N values in a group by using a parameter table. #dataquerying #powerbi #powerquery #mquery #excel #dataanlysis #data
Project File
github.com/jbo...
Functions Used
List.MaxN
List.MinN
Table.Transpose
Table.Sort
Table.AddColumn

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

 

30 сен 2024

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 12   
@Bhaskar_Joshi_there
@Bhaskar_Joshi_there 10 дней назад
You're always working with Share Market data, so it seems like you have an interest in investing. I'm curious... do you consider yourself a good investor? Have you made it to millionaire status?
@basensei8699
@basensei8699 10 дней назад
ye man i love the investing landscape it's my day job. i'm fascinated by markets demand and supply and how price reflects what people perceive to be valuable.
@txreal2
@txreal2 11 дней назад
Can’t get enough from BA Sensei. Thanks
@basensei8699
@basensei8699 10 дней назад
glorious it's a great pleasure!
@kebincui
@kebincui 10 дней назад
Excelletn as always. Thanks James 👍👍
@basensei8699
@basensei8699 10 дней назад
awesome thanks man!
@mnowako
@mnowako 11 дней назад
Amazing! Thank you!
@basensei8699
@basensei8699 10 дней назад
glorious!
@arnaudallard3663
@arnaudallard3663 11 дней назад
Brilliant as always 👍
@basensei8699
@basensei8699 10 дней назад
awesome thanks man!
@themolestones
@themolestones 11 дней назад
brilliant, thanks
@basensei8699
@basensei8699 10 дней назад
You're welcome!
Далее
Power Query - Get Top N by Group
22:19
Просмотров 1,8 тыс.
Dynamic Snapshot Emailed to you with Power BI
14:56
Просмотров 1,7 тыс.
Power Query - Adding a Conditional Index Column
12:18
Просмотров 2,2 тыс.
Power Query - Understanding each and underscore (_)
12:41