This tutorial will discuss Power Query functions, keywords, and pre-defined identifiers. You’ll learn what they do and how to use them in developing codes and formulas. You’ll also learn how to access function documentation to get information and examples for your report. Keywords And Pre-Defined Identifiers Keywords and Pre-Defined Identifiers can’t be redefined. This is
Category: Power BI
In this blog, I’d like to give you some Power BI design tips on how you can make your reports look more application-like by simple hiding pages. This is a methodology that I’ve seen being used in many of the best and most compelling reports I’ve encountered recently. I think it’d be a great trick
In this tutorial, we’ll talk about a Power Automate control that terminates actions in a flow. If any of the conditions in a Switch case was not met, we’d want to display an error message and terminate all the actions within a flow. In such scenarios, Power Automate Terminate action control comes in handy. The
In this tutorial, I’m going to show you the basics of PowerApps galleries. A gallery is a list of records, with every item in the record coming from a table. The example I’ll be using here shows one of the most basic galleries you can build using Power Apps. Power Apps is an amazing tool
In this tutorial, you’ll learn about nested expressions, objects, and environments in Power Query. Nested expressions and variables will be used to discuss how Environments work and help generate data. You’ll also learn to deal with common scenarios when transforming nested objects. Creating Nested Expressions Expressions are defined as a formula used to construct value.