PowerQuery Parameter in Excel

I share in this post how you can define Parameters for Power Query in Excel.

Use Data Model Relationships instead of XLOOKUP/ INDEX/MATCH in Excel

I share in this post a recent learning about how to use data relationships in Excel (instead of e.g. INDEX/MATCH or XLOOKUP)

Excel: PowerQuery Table with Excel Custom Column: no overwrite

I share in this post a nice learning / feature in Excel PowerQuery

Excel Transpose Data

Excel challenge: How to transpose data in Excel from horizontal to vertical

I present here a solution beyond using the Transpose Excel function based on Power Query.

Excel Index Match

I have stumbled recently again upon the Index/Match combo and forgot that the 3rd argument in MATCH is most needed and shall be set to 0.

PowerBI/ PowerQuery: How to get Jira Issue Field Value by Name

I share in this post my learnings and code regarding how to get a field value of a Jira issue in PowerBI/ PowerQuery.