Top "Powerbi" questions

Power BI is a free, self-service analytics tool available individually or integrated with Microsoft Excel, Office 365 and all major Databases and analytics tools.

Power BI (DAX): Distinct Count Filtered by Condition

I have a data set with publishers with revenue by month. Publishers are considered to be "active" month if their …

excel excel-formula dax powerbi
Passing parameters to Power BI filter programmatically

In my application I'm displaying a Power BI report. It already works, so there's no problems with showing any report …

filter parameter-passing powerbi powerbi-embedded
What's the difference between DAX and Power Query (or M)?

I have been working on Power BI for a while now and I often get confused when I browse through …

powerbi dax powerquery m
Custom sorting in PowerBI chart

Recently I came across one issue in which I need to show the column order as per my defined way …

sorting powerbi
How to calculate cumulative Total and % in DAX?

This might be very simple... I have the below summary table in Power BI and need to build a Pareto …

powerbi dax running-total cumulative-sum pareto-chart
How to Do Countifs/Sumifs in PowerQuery M.Language Formulas?

Is it possible to Do Excel's Countifs/Sumifs formulas in powerquery Formulas? Let's Say I have [Column1] as "Criteria range" …

powerbi powerquery m
How to substitute NULL with value in Power BI when joining one to many

In my model I have table AssignedToUser that don't contain any NULL values. Table TotalCounts contains number of tasks for …

powerbi dax powerbi-embedded
A table of multiple values was supplied where a single value was expected, when using Distinct

I have the following table: I'm trying to create a new column using Dax language: Column = DISTINCT('Edição'[Paí…

powerbi dax powerbi-datasource
Creating a Measure that returns DISTINCT COUNT by Country and Brand in Power BI

I have a table like below: Country, Advertiser, Brand, Spend C1, A1, B1, 10 C1, A1, B2, 5 C1, A2, B3, 0 C1, …

powerbi dax powerbi-desktop
POWERBI - Object reference not set to an instance of an object

I'm trying to connect oracle database using prowerbi desktop. Throwing following error Details: "An error happened while reading data from …

powerbi powerbi-datasource