I'm looking for a way to automate some daily tasks. Right now I have about 30 different workbooks, each for a different company for personal property tax returns for 2017. I'll now be starting new workbooks for 2018 personal property tax returns for those same companies. I'm wanting to be able...
Recently I learned about the PowerBI features (Excel's data-model, Get&Transform, etc.). This seems like THE thing I need in my regular job, as I keep compiling reports from different data sources and updating them.
My question is:
What is the proper way to regularly update data if...
I have big data I want the opposite values from the slicer filter.
I have all Players name for Spanish League
When I filter (from slicer Filter) Real Madrid I Get all players name except Real Madrid Players names
My Other concern is how to use this Slicer Filter to exclude in...
I am working in Power BI.
My primary data table has a variable called "Distance" which is recorded within three levels: "Session", "Athlete" and "Drill".
In other words, within each Training Session, multiple Athletes participate in multiple drills, all of which have an...
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 sales data and products table
And I want to find out what is the best product sold with each product
If market have tea, sugar, spoons, plates and cups
After some bills come he found out there is relation between tea and sugar and cup
So he'll make an offer of tea, sugar and cup...
Hi. I’m looking to replace our computer at the office. It is currently a Xeon processor with 32 gigs of RAM. We connect to a sql server that is located on site and the current Excel file size is 100 MB. I’m looking to get a very powerful system as we live inside excel numbercrunching. What would...
We operate Mon-Fri 9:00 to 17:30, I have two fields called [Request date] which is the start and [Assigned date] which is the end.
I wish to compute the difference in minutes, however bearing in mind business days and hours mentioned above.
So, (probably not a good example)-if a ticket was...
I have following table.
No of stores
No of sales
I want to display year end figures in the pivot table. I have created a...
Hi, Ive been trying to make a power query to merge two tables and keep them updated with new inputs every month. Hope that its not too confusing.
The idea is as follow:
1. Two separate tables, with one common column (EAN number), is imported into to individual queries by adding a custom...
Hi everyone, I am conducting a marketing research survey on the needs of individuals who use Microsoft's Power Pivot/BI products. This survey is very brief and completely anonymous. My goal is to better understand what resources people are looking for on excel and Power Pivot/BI, and what...
Dear all ,
i am experiencing this problem in power pivot where the power pivot is showing the " ; " symbol instead of the actual data in power pivot which is Pepsi Cola.
Any body knows why this is happening , Thanks
Failed image removed by moderator
Hi I'm trying to write a cube function that has just todays sales.
Currently i have a slicer for month and year.
=CUBEVALUE("ThisWorkbookDataModel","[Measures].[SALES TOTAL NET RETAIL]",Slicer_MONTH1,U$6,Slicer_YEAR1)
But I would like to have just today. IE TODAY()
I've tried this but that...
Hi I have a cube function with an issue. How do I handle any part of the equation where there is not values. There are 3 formulas and i receive a #Value if there is nothing for any part of the formula.
=CUBEVALUE("ThisWorkbookDataModel","[Measures].[1YR AGO OH RETAIL]",'MONTHLY...
Hi I'm wondering if it is possible to use the DATESBETWEEN function using dates from 2 cells.
I would like to run my inventory as of a date last year.
I will be taking the current on hand, + units sold today to last year, - units received since start date.
I would like to have a cell that the...
Hi I've created an Excel sheet with 100 or more DAX measures.
When I update they all get calculated and it takes about 5 minutes.
Will more measures slow it down even more?
I've also converted some PIVOTTABLES to OLAP CUBEFUNCTIONS. How does that effect the speed and processing of the sheet...
In PBI, we have very few ressources for work with addressing/variable/dimension. Basically, we have 2: Table and Colommun.
Table1[Colommun1] Table1[Colommun2] Table1[Colommun3]
Table2[Colommun1] Table2[Colommun2] Table2[Colommun3]
Hi I need assistance on a DAX formula. I would like to total last years sales to add back to my OH as of today.
This is what I have for calculating last years sales as of today. But I want the start date to be able to move as the month advances.
UNITS SOLD LAST...