Good morning - I have a fiscal calendar that my company creates which I pull into Power BI. Columns include date, fiscal year, fiscal week, day of week, work day, holiday, holiday name, week of month, and fiscal quarter.
What I want to do is creat a few custom column in power query that will...
I have a query that retrieves information from multiple excel files in a folder
The problem I am running into is that those files have formulas that depend on the current date
Seemingly, when power query retrieves the data, it doesn't allow the formulas to update first
This results in incorrect...
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'm looking for help on creating a measure that give me an overall score based off of other score Metrics.
I have 2 tables:
First table provides the employee scores for the metrics being measured:
Friday, June 28, 2019...
Looking for some help here - I havent been able to find a solution anywhere.
I have a matrix table that provides a view of aging inventory. For each client they have a number of days to work the ticket before it is outside of SLA. I want to add a column that shows when those...
I need a DAX measure that compares latest version of financial data against prior version
My data table has an'asof' column to tag which version the data originates from (100K+ rows)
For example, I would like to compare the full yr 2019 cash number asof Sept 2019 vs. the full year 2019 cash...
So I have this formula in excel in my raw data
=COUNTIFS([Date range],">="&(EOMONTH(Date,-1)+1),[Date range],"<="&EOMONTH(Date,0))
Power BI however doesn't have this function. I tried to use Calculate, but it is still confusing for me to understand some of these formulas.
Can you please show me...
Hi to all,
I managed to get in Excel desired % of time difference from column E, easy job just changed the Data Type to Percentage. What are we calculating is % of these TimeDifferences, one per one (other columns inconsiderable). The calculation I used is: MOD(D3-D2;1) and Column F (%) is just...
So far throughout my searches I always end up being offered MS Cognitive or Azure.
Is it possible to somehow teach Power BI to recognize phrases with Python/R (or any other accessible tool) or build some neural network in Power BI to recognize them.
Word Cloud is not helping much, as it...
I've been using Excel for years but have recently been seduced by the appeal of Power BI as a means of providing more 'visually friendly' reports for other users to view and analyse. Whilst I can generally get Excel to do what I want to do (possibly through horrendously inefficient...
I am trying to find Employee turnover by Year/Company
I have and employee table and I have created a Calendar table
The employee table has the following columns
I would like to createa dashboard to show by
Company turnover % by Year (2018 &...
Hello dear Power Bi Community,
I'm pretty new into Power BI, so please excuse if I might need some pretty basic help here. I was trying to find some help here already and eventhough similar posts exist, I didn`t find anything yet which would cover my specific needs.
I would like to...
I' am hoping you can help, below is my code for a PowerBI Query..... the sales data is my main table of data and the "AndCriteria" are filters such as dates names referenced from a cell... for example if someone enters date 01/01/2019 in cell A2 then it will return data from that date...
So I have 2 fields
Both can contain similar information, thus both can contain specific info.
So far apps provide only AND operator. If I create filter for Problem and Work Performed. I will either miss information if one of the fields doesn't contain keyword, or I don't...
I need some help with a PQ Merge issue i have to tables that i merge with the simple idea via a SKU it collects Categories from another table. All SKU's are present and the Cats are also listed. THis worked but when i add new items the Categories are not being picked up.
I have added...
Hello experts of Power BI,
I have a table that has three columns, one is the name of the person, one is the date they entered and the last column is the date they left. I am trying to create a new table or measure on Power BI that calculates the occupancy for each patient per month. For example...
I have many measures (f.e. GDP:=sum([total rev])...) and I want these measures to have assign a characteristic (f.e. CF, or PL, or BS). Is there a way to map a measure to a characteristic in a data model?
Thank you in advance
Hope all is well
Thanks for taking the time to read this.
I have recently started with Power BI, previously relying on Microsoft Query to pull data into Excel to manipulate.
Looking for any guidance to getting Power BI set up to replace / refresh Microsoft Queries.
In principle I...
Hi, our software supplier is going to send us via FTP a list of 20 CSV files with our data. The software supplier will send us an updated copy of each of the 20 files each day to our FTP folder. I'm going to set up Power BI to create visualizations using the daily data dump. The 20 files will...
Hi - hope you can help
I have two tables.
A fact table - Table 1
<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>#DAE7F5[/URL] "]