I want to relate multiple table together to a single field, and that way I can use data from multiple tables in a single visualization. Can someone please tell me if this is possible and if so, how?
Thanks. The tables |I have contain duplicates.
Good evening everyone,
I have a model from powerpivot which its fact table has many colums. I wish to insert multiple pivot tables, each with unique columns. I know I can hide tables and columns from client tools, but this will hide the columns or tables I select for all the pivot tables I...
I am trying to create a dax measure by doing the following: -
1. I have a measure named "Consumed Data" that gives me the amount of data consumed since the start of the month.
2. I have a city names in a column "City" of table "Location". I want the city to be "London".
I want to filter data inside the R script in the R visual, so I can make and display calculations such as covariance and others based on the years the data was collected.
I tried this:
I am trying to subset some information imported from a json into power bi.
I tried the code in RStudio and it worked, but when I imported this code in Power BI, it didn't show any results.
I converted the data into a data.frame, but that didn't work.
can someone please help me.
the code I used...
I was wondering if its possible to use R functions to obtain numeric results in Power BI, with information already imported in Power BI?
I know that there's an option for R script in Power BI, but that is a visual and there is another one but that makes me paste a script that pulls the...
I want to use a google sheets formula in power bi, but I am unable to use it, since there is no image function in power bi.
This is the function I need to use:
Can someone please help me find a way to...
I have generated an excel sheet in google sheets, that gets the history of currency rate changes from some coins to USD. What I want to do is compare the date of the column in google sheets with a dummy table with dates and if they match, then multiply the value from the rates column to the data...
I ask to compute attrition rate from two different data sources. I have 2 different sources:
1st: employee headcount (one row per employee) which has all employee details such as Name, ID, Date of Joining, Supervisor name, Department etc.
2nd: showing data for employees who resigned
Apologies in advance for my PQ ignorance as I'm fairly new to its use. I do, however, feel I've combed the internet in search for an answer to my question, have not found it, and, thus, have landed here :)
1) I "Power Query" a local unedited excel corporate-provided report and begin my edits...
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...
I have a folder of files that I am querying for the files' date modified, file size, and a few other attributes. Long-story-short we have multiple versions of these files in subfolders and each "release" we make a new folder and copy the Excel files into them. So I created this query that can...
I am using power view (power maps) to plot plants and supplier location. I was successfully able to do so using city and state. Next, I would like to create radius circles based on distance (miles) around each supplier to identify what the closest plant is based off a 50 mile radius. Does...
My company works with a crm system that is not in-house. I have tried to convince the supplier to give me access to a “real-time” copy of the database. I would like to access all our information to work with in Excel/PowerPivot and in Power BI. I have 3 questions I would need some help with. I...
I’m trying to get all work items related to a Visual Studio Team Services board. I’m surprised there is no “Get all work items” query in the API that Microsoft has published here: https://www.visualstudio.com/en-us/docs/integrate/api/wit/work-items
So therefore I made a custom query in VSTS...
I have created a model in Power BI desktop, published it to power Bi online. Everything works fine with my personal gateway. But, I can’t switch to use my company’s enterprise gateway. I have a couple of different sources in the file. Mainly mysql-databases. But I think it is Google...
My data is below and I need to COUNT where Area Name = Area 1 and Month Tagged = May-16?
Table Name = 'rawdata'
Hello, I am having trouble setting up a pivotchart and was hopin to get some input.
My data consists of the following:
1 column of US Regions (South, East, etc)
1 column of US State
1 column of State's population.
The chart is just a standard bar graph.
I want the chart to display the 4 US...