Peter HuiinCodeXPower Query — List functions to help you…select columns with multiple criteria'sJan 21, 20231Jan 21, 20231
Peter HuiinCodeXPower BI- Field Parameters…is something you need to make use of!Sep 19, 2022Sep 19, 2022
Peter HuiinCodeXPower BI Functions — Table.ColumnNames, List.Select and List.CountFinding relevant tables to work with within a bunch of CSVs can be very difficult. Finding these files with little to no documentation can…Aug 20, 2022Aug 20, 2022
Peter HuiinCodeXDAX, SQL and R…grouping and summarizing data.With examples of course!Feb 25, 20221Feb 25, 20221
Peter HuiinCodeXDAX, SQL and R — Cumulative Sums with groupings…with explanations.Feb 10, 2022Feb 10, 2022
Peter HuiPower BI Modelling — Inheriting a messy model.… what to do in these situationsJan 31, 20222Jan 31, 20222