Invoke Custom Function Power BI

DAX Functions:

Power BI uses Data Analysis Expressions (DAX) for creating calculated columns, measures, and tables. You can call various DAX functions to perform calculations and manipulations.
Calculated Columns:

In Power BI, you can create calculated columns within tables by using DAX expressions. These columns can perform calculations based on existing columns in the table.
Measures:

Measures are dynamic aggregations or calculations that are computed on the fly. You can create measures using DAX functions and use them in visualizations.
Row Context and Filter Context:

Understand the concepts of row context and filter context in DAX, as they play a crucial role when invoking functions. The context in which a function is evaluated affects its results.
Parameterized Queries:

Power BI supports parameterized queries where you can define parameters and use them in your queries. This allows for dynamic data retrieval.
Power Query M Language:

Power Query uses the M language, and you can invoke functions using M expressions for data transformation and cleaning operations during the data loading phase.
Custom Functions in Power Query:

Create custom functions in Power Query using the M language. These functions can be invoked across multiple queries to maintain consistency in data transformations.
Conditional Logic:

Utilize DAX functions for conditional logic, such as IF, SWITCH, and CHOOSE, to control the flow of calculations based on specific conditions.
Parameter Tables:

Create parameter tables in Power BI to store parameters that can be referenced in DAX expressions. This enhances flexibility and reusability.
Error Handling:

Implement error handling in DAX expressions using functions like IFERROR or TRY...EXCEPT. This ensures that your calculations gracefully handle potential errors.

[jiecao]

Thank you for using the web data as your example, I could use it and follow your steps to try it by myself! The only issue I came across is when I pulled in Highest worldwide table, Power BI automatically promoted the first rows as my header, and changed the data type. Rank field was changed to whole number data type and caused the issue for the following steps. After changed all data type into text, everything works perfect! From your illustration, I didnt see the promote header step though.

[TehsimShaikh]

Can i use a Rest Api where i want to replace the Project name in the middle ?

[anuradhachaturvedi]

Thank you for sharing the example. It worked really well as I had to merge 25 google sheets. However I am unable to set a refresh schedule on Power BI Service for the same. It gives an error "Something went wrong

This dataset includes a dynamic data source. Since dynamic data sources aren't refreshed in the Power BI service, this dataset won't be refreshed."
Is there a workaround for the same?? Your early response would be highly appreciated.