Peter Hui – Medium

Pinned

Peter Hui

Power BI modelling

Some tips. Wish I had known them before.

5 min readOct 8, 2020

--

2

Power BI modelling

--

2

Peter Hui
in
ILLUMINATION

Squeeze your glutes!

…huh??

3 min readJan 23, 2023

--

Squeeze your glutes!

--

Peter Hui
in
CodeX

Power Query — List functions to help you

…select columns with multiple criteria's

3 min readJan 21, 2023

--

1

Power Query — List functions to help you

--

1

Peter Hui

My journey with Power BI…

here are the best tips I remember

5 min readOct 2, 2022

--

My journey with Power BI…

--

Peter Hui
in
CodeX

Power BI- Field Parameters

…is something you need to make use of!

3 min readSep 19, 2022

--

Power BI- Field Parameters

--

Peter Hui
in
CodeX

Power BI Functions — Table.ColumnNames, List.Select and List.Count

Finding relevant tables to work with within a bunch of CSVs can be very difficult. Finding these files with little to no documentation can…

3 min readAug 20, 2022

--

Power BI Functions — Table.ColumnNames, List.Select and List.Count

--

Peter Hui
in
CodeX

Power BI — SUMMARIZECOLUMNS

…a very underrated function

3 min readAug 15, 2022

--

2

Power BI — SUMMARIZECOLUMNS

--

2

Peter Hui
in
CodeX

DAX, SQL and R…grouping and summarizing data.

With examples of course!

3 min readFeb 25, 2022

--

1

DAX, SQL and R…grouping and summarizing data.

--

1

Peter Hui
in
CodeX

DAX, SQL and R — Cumulative Sums with groupings

…with explanations.

3 min readFeb 10, 2022

--

DAX, SQL and R — Cumulative Sums with groupings

--

Peter Hui

Power BI Modelling — Inheriting a messy model.

… what to do in these situations

6 min readJan 31, 2022

--

2

Power BI Modelling — Inheriting a messy model.

--

2

Peter Hui

Peter Hui

I write about Power BI, Power Automate and other cool Microsoft power tools. Microsoft certified data analyst. Constant learner and an aspiring writer. 👍

Following

Help
Status
About
Careers
Blog
Privacy
Terms
Text to speech
Teams