Power BI

In this blog we will learn about What is a Record, Extracting Records from a Table, Creating Records from Scratch. Also, there are two practical Examples of using Records that might be helpful in many different ways!

Get the equivalent of Excels FV function to calculate the future value of a series of payments for Power Query as well.

Get the equivalent of Excels PV function to calculate the present value of a series of payments for Power Query as well.

We cannot apply conditional formatting for line charts in Power BI to control the colors of the lines. But sometimes we want to fix these colors. Let’s see how we can do it.In my previous article, I …

Contribute to PBI-David/Deneb-Showcase development by creating an account on GitHub.

Shared via Flipboard

In this post, we examine how personal data can be used in personal projects to help us learn Power BI.

Our cool new house needs one more plank in its foundation.

Metrics layer is the rising “missing component” of the modern data stack. I dive into functionalities provided by 10 prominent players in the space and contrast them with a player no on…

Bug-free development with BDD. ✓ Automate tests in your native language ✓ by using the easy to understand Gherkin syntax. ✓ for .NET.

Being able to construct DAX queries dynamically in C# means the possibilities are endless in terms of integrating Azure Analysis Services queries into your custom applications, and with the code samples in this post, you have everything you need to get started.

An introduction to the basic syntax of Rel.

Despite being inherently difficult to test, the need to validate data modelling, business rules and security boundaries in Power BI reports is important, as well as the need for ensuring that quality doesn't regress over time as the insights evolve. This post explains that, by connecting to the underlying tabular model, it is possible to execute scenario-based specifications to add quality gates and build confidence in Power BI reports, just as any other software project.

With a variety of integration support through client SDKs, PowerShell cmdlets and REST APIs, it can be hard to know where to start with integrating Azure Analysis Services into your custom applications. This posts walks through the options, and lays out a simple guide to choosing the right framework.

One of the first steps in integrating Azure Analysis Services into your applications is creating and opening a connection to the server - just like any other database technology. This post explains the ins and outs of creating Azure Analysis Services connections, including code samples for each of the key scenarios.

Text is the most under utilized tool in visuals. Few days ago I saw a post by Christopher Chin where is showed a unique way to show legend in a visual, and I was trying to figure out how to recreate it in PowerBI such that it is dynamic(change with filter) and show different color is a single text.

I often get asked which tool or language I would recommend for creating data visualizations. Like many responses in the world of technology (and perhaps the world in general as well), the answer is almost always "It depends.

Metrics layer is the rising “missing component” of the modern data stack. I dive into functionalities provided by 10 prominent players in the space and contrast them with a player no on…

I have a confession to make. I have to try to not be judgmental when I see one of the old Power BI icons on new content that’s being published. The thing is, the old icons still pop up a LOT on blog posts, social media images, and even advertisements for paid training offerings.

People have done creative things with SVG measures in Power BI, ranging from KPI cards to infographics to fun games. For my latest Workout Wednesday challenge, I used SVG measures to make holiday c…

Learn how to leverage the features of the Bookmark Navigator button to implement an easier solution for creating on/off (toggle) formatting for a single button. Tune in to learn more! Video by: Reid Havens

Figma design systems are an excellent resource for BI developers who want to deliver well-designed dashboards.

This is the second installment in our two-part series on DAX window functions announced in the December 2022 release of Power BI Desktop. I will first answer the questions that I had received from …

The December 2022 release of Power BI Desktop includes three new DAX functions: OFFSET, INDEX, and WINDOW. They are collectively called window functions because they are closely related to SQL wind…

This video explains how to create a Bravo for Power BI template to customize a Date table and the related Time Intelligence measures created by the tool.

The filter arguments in CALCULATE can be written as logical conditions with certain restrictions. This article explains the more common errors in these cond

New window functions are one of the most important enhancements to the DAX language ever! Learn how to leverage them to calculate a customer lifetime value.

Explaining changes between snapshots is not easy, but calculation groups can help show exactly what happened in terms of Value changes, movements, etc.