Excel import

single choice sheet

Delete navigation

Expand source data

Delete other columns

Folder import

Delete other columns

Add custom columns

M function calls Excel data

Expand custom columns

Expand data

Delete other columns

Filter out titles

Each function call must have a function package/class

Capitalize the first letter when calling a function

{}List

[]record

List.Sum()

List.Min()

List.Average()

Text.Remove()

Text.Select()

Text.Length()

Text.Start()

Text.End()

Text.Trim() removes text spaces

other

Excel.Workbook()

Csv.Document()

if then else

(expression, filter1, filter2, ...)

Change context through filters and aggregate operations in expressions

return value

Row context can be automatically converted to filter context

FILTER

ALL

VALUES

There must be a complete and standardized date table: including dates throughout the year without repetition

How to make a search date table in the public account PowerBI planet

VAR variable name=expression RETURN result expression

You can use VAR to define multiple variables, but only one RETURN

Improve code readability and computation

none

filter

highlight

tooltip

Type: report page

Page number: Tooltip

Draggable measure values ​​into

Secondary folder input: first-level folder\secondary folder