I everyone, im new in power bi / power query and I need to know how to create a column in a table IF the value of a specific column is between a range of one of two different column values.
Something like: create a column 4 where the value is the same as the value in column 1 IF this value is +...
I noticed something odd today and I don't know if this is new or if I just never encountered this before.
I have 3 files in a folder and imported from the folder into Power Query.
2 of the files have 2 columns, 1 file has 3 columns.
Power Query imported just the first 2 columns from each...
I have a Start Time and Stop Time column in my Excel spreadsheet that is feeding the Power BI reports. Time is entered in military time, however I cannot make Power BI Calculate the difference properly when the Start Time is one evening and the Stop Time is the following days morning (i.e...
I very new to using Macro.
Can some one please help me with a code to open all the below applications once I run the Macro.
Adobe Reader DC
Microsoft power point
Any help is really appreciated
I am using an Excel workbook with several tables to create a Power BI Metric package that publishes to an internal SharePoint site. The employee responsible for updating the Excel workbook is not capable (via access or skill) to refresh the Power BI dataset. How can I automatically get the Power...
I have a Excelfile with a power query model in it.
It works fine on one computer, but when I run it in on another computer there are errors.
I use excel 2016 on both computers but the one with errors crashed a couple of weeks ago and got office reinstalled just the other day.
Hi - I have a problem with power query not updating all data from my source file.
My query was created from file / from folder, and I currently only have a single file in that folder at the minute. I have imported that data into power query with no issues currently, however if I change some...
I every one, i have a problem...
I have created a table in dax, like this
NISCountLT2 = SUMMARIZECOLUMNS(LT2[ID]; "Total"; COUNT(LT2[ID]))
to count repeated IDs
then i use this code to create a column with ranges for the report
Bucket Range = SWITCH( TRUE();
I have been asked to analyse Quarter monitoring fromcompanies into power bi
The monitoring forms are in excel format with for Q1, and the other tabs would have Q2, Q3, Q4 tabs. the monitoring formformat does not change for each quarter.
The information is input into...
I have a Dimension Table and a Fact Table brought in by Power Query. In Power Query, I added a Calculated Column to each table named "Report_ID". I'm trying to create a relationship in Power Pivot for these tables, but I keep getting the error message that Power Pivot does not currently support...
i have a problem, I want to create a single column from the combination of 2 others from diferent tables...
these columns have a null value or a numerical value, like this:
COLUMN_TABLE1--COLUMN_TABLE2 ----- WANTED COLUMN_FROM_ANY_TABLE...
I am just discovering the power or Power Query for Excel
I need to run merge queries to populate data on my daily file from the same master file every day and am trying to streamline the process.
My current process
Open my daily file
Get & Transform From Table/Range
In power query editor.. New...
I am pretty new to Power Query so please be gentle!
I have a table with 2 column's from a database. The first column is a Parent recipe, the second column is a Child recipe. Recipes will be found in both columns so no unique records.
Hello, first that all excuse me for my bad english ;( I need your help, im new with power BI
I have a table named LECTURA that contains a column named SMS. The column SMS have a lot of values, and i need to change the value of a part of it.
The values i need to change have the structure...
I have Power BI Pro installed as part of our E5 license and I am trying to evaluate it in thoughts of using it instead of our current IBM Cognos setup (that we pay extra for) fo rquerying our SQL server tables...
However, the one concern I have that I do not think Power BI can do - but...
Hi, my company is prepared to put me through a Power BI course and have asked me to find a course that fits our needs:
> Preferably a week / 2 week classroom based intense course
> Certification included, Microsoft 70-779, MCSA or MCSE exams as part of the course
> Preferably a Microsoft gold...
I'm using Power Query for Power BI Desktop and when I connect to a single PDF file the last record only shows the data for the first page and not the rest of the pages. The rest of the data is the same as the first page. Can Power Query read multiple pages for one PDF? If so, how can I...
I have about 40 files that I need to append through Power Query. In my model the user selects a month and then the sheet with that month name is consolidated. It works great until someone uploads a file that doesn't have any sheets with that month name. How can I get power query to...