power bi desktop

I am trying to improve the performance of my Power BI queries. From an SQL database I created two tables "Data-Historical" which is set for data pre-2018, I have also Unchecked both Enable Load and Include in report refresh "Data-Current" which is set for data in 2018, I have also Unchecked...

Hi Everyone, I Have a following table from which i created my Power BI Dashboard. <tbody> Table:-1 City Product Revenue Mumbai Desktop 953774 Mumbai Keyboard 793440 Chennai Laptop 391087 Kolkata Mouse 188533 Delhi Keyboard 943413 Mumbai Laptop 317314 Chennai CFL 157082...

The reporting in our hospital's electronic medical record system is horrible, so I've exported some of the data, and I'm using Power BI to create reports and dashboards for the Physio department. There are 2 main fact tables - one with all the encounters that patients have with doctors (fDr...

Hello everyone! I have a query here wich contains 10 different columns. I need to create 4 other columns (A B C D), with formulas that contains values from this 10 first columns. One of my inicial columns is called "Period", and it starts in 1. So, when period is equal 1, colunm A is...

I have a desktop PowerBI file created from a PowerPivot model using File | Import. I updated the source Excel file with a new table using PowerQuery and I would like that table to also appear in the PowerBI file. I can't figure out how to do that. If I try File | Import again it blows away my...

Hi Does anyone know how to remove (Blank) from a tile when no data is present and replace with a zero? im new to the tool so any help will be greatly appreciated Rosco

I need a function or any other method to concatenate multiple function, add "|", and replace " " with "%20", without having to do this 1 by 1. If someone could show me how to do this, I would be really grateful. Thanks.

Hi Everyone, I have two tables, One is Budget Table and another is Expense Table. In both the tables there are two columns which are common. One is "Quarter" and another is "Budget" Column. I want to create relationship between both the tables and create a Power BI dashboard with these two...

Hi everyone, I have a problem which I'm hoping one of you will be able to assist me in solving. My dataset consists of hourly sales by sales rep. The relevant columns are: ID (as Integer) <-- This is a unique identifier representing a sales shift. For a given rep on a given date, there should...

When I create a relationship between two tables, it says each column has duplicate entries. How can I delete them? I just have to check my primary key column and remove rows of duplicate entries. Thanks in advance

Hi! I want to calculate changes in the prices of companies. (one year change). My table looks like this Date-------Company-------Price 2001-------A----------------20 2002-------A----------------25 2001-------B----------------30 2002-------B----------------35 So i have to calculate the % changes...

I am making a database to run some regressions on Eviews. So once I'm done with the table, I have to export that table to Eviews or any other statistical software. But I'm not sure how to export a table or tables from data model. If I cannot do that, then no point in spending time in the power...

Hi guys! I have a data set which looks like this. Company-----01/05/14-----01/05/15---01/05/16 company A-----1,984----------2.500---------3,000 company B-----1,984----------2.500---------3,000 company C-----1,984----------2.500---------3,000 company D-----1,984----------2.500---------3,000 I...

Hi Guys! I was trying to calculate Numeric Distribution in Power BI Desktop (Uses DAX). Numeric distribution means that you look at the number of outlets you are present in (e.g. Heineken is being sold in 800 out of 1000 bars = 80%). It should be able to do this with just 3, columns: Outlets...