I am seeking for answer about Performance of Power BI.
Originally I had 2GB Access database, converted into Power BI, with some other small tables it give me 130MB PBIX.
After creating the model I realized it is too slow, does not pass "3 sec" test.
I did following steps:
I was going through some sale data which had customer name, item code, item description, cost/unit, quantity and value.
By using the new trigonometric DAX functions available in Power BI desktop, straight-line distance on the Earth can be calculated. The new DAX variable feature also comes in handy in constructing this useful formula.
I am working in Power BI Desktop (Similar as Power Query) which uses DAX. I have 3 columns:, Response ID, Brand and Volume. Since I have around 50 brands per ID, the Response ID is shown 50 times. Now I want to summarize the total volume PER Response ID in a separate column, but when...
I'm very new to Power BI. My goal is to do the follow. I work for a transportation company and we have the follow objects.
Load : 1 Truck Load - (Consists of Shipments, each Shipment contains Items)
Shipment : 5 -6 on a Load (Each Shipment represents 1 pick up at a new address)
Hello all, in need of some "M" wizardry to recreate the functionality of this SUMIFS formula. My current skill level with "M" consists of hastily key-word searching the M formula language .pdf so a SUMIF is way over my head. I'm using this SUMIF to compute a running daily balance based on each...
I work with generators and 100MB time series CSV data files are generated every day (250K rows), as shown here: https://www.dropbox.com/sh/d57qcdkx6087u72/AACv4MqXDmpVrxN-Qci0Pjida?dl=0
I am interested in zooming in/out of chart that has 4 variables plotted against time. Then consolidating...
I am creating a Dashboard. Dashboard is feding from 3 Excel Shets. Those excel sheets have same variables and only amounts changes. I am doing all dashboard againts the last sheet (more recent) but i would like to introduce an overview of how the amount changed...
How can I remove rows based on cell contents being 'null'.
I could manually do it in excel by using special to delete them but would like it as part of the query.
My column which appears about halfway across my sheet is this.
edit: number4 is the column header.
I have two tables with property information. Both tables have effective dating (from and to date). They are related through a property dimension table (lookup table).
The first table (PropertyFact) stores the size of the properties and the occupied space. A new record is added when the...
I'm able to create the value I need using a calculated column and the following formula:
"=LOOKUPVALUE([Total Volume],[Time],"YTD Dec 2014",[Location],[Location]"
I'm trying to create the same result for each record using the "Calculated Field" functionality to conserve space and not create a...
Hi I am curious how to update my Excel/Power Map to take advantage of the new filter feature. When I go to Excel/Account/Update.. it tells me I'm up to date... but no filter in the map..
Is this the right path to update Power BI?
I'm trying to create a dynamic tool that references end user input in the query and performs operations on the source data.
Right now I have a table on a spread sheet where a user can provide input which is then called in the query to create a custom column. The inputs correspond to...