power bi

Hi All and welcome to the forum, I’m looking for help in writing the formula for the below business case. First, let me give you an overview of the dataset and what I need to calculate. Data Data set is a table that is a result of appending hundreds of reports. There are two relevant...

Hi All, I am currently facing an issue in with my pivot table that I have been absolutely unable to fix and it does not seem like the Power Pivot forum is very active compared to this one. In addition, mine is more related to Pivot Tables than Power BI, Query or anything like that, so I may...

Dear all, I have currently made a pivot table, which I am linking to some Power Query data. The data in the power query comes from a folder where I import files from a website, so these files will ALWAYS have the same file name, sheet name and column names. However, the data under their...

Hi, I'm using the below code to retrieve amounts on the last posting date. LastPeriodSelected = CALCULATE ([FinanceAmountMeasure], FILTER ('Date', 'Date'[Date] = max('Consolidated Accounts'[PostingDate]))) I have a filter on the visual on the current year and selected months. My question...

Hi, A question for Power BI users. Have tried searching for this question, but no luck; and I hope I can explain it properly. I have data that contains a parent code, and a city, with Yes and No answers. I have created one measure that gives the % of Yes to No. I have created another...

Hi all, Thank you for taking the time to read, and hopefully reply. Much appreciated. So I have a dataset where I only have YTD financials per month. So each month I will get a new dataset from our financial vendor, and I now have a new YTD figure per account for that given month (and periods...

Airport Delays and Covid Cases Pivot Table I have two tables joined to a Date lookup table. My flight data doesn't have data for October 2021 to December 2021 but my cases data does. How do I exclude the blank rows automatically without have to click filter blank rows manually. Is this...

Hi all, I am a novice and learning as i go along and I was wondering if i could tap into your expertise. I have a folder with about 100 of these files to impot which i am trying to merge into 1 master file. Each workbook has a similar format in terms of structure. However, the store number...

Hello i'm in need of some expert help with a Matrix, i'm trying to created a matrix where the column heading to the left, then the value to the right for multiple rows. I'm not sure if this is possible with a matrix but looking for any suggestions are greatly appreciated!

Hi there, I work for an accountancy firm and working with multiple data tables for debtors, work in progress, time and fees. They all have different date periods but I am trying to merge data so each client shows for all the elements. For example for end of Oct, I would like to show what the...

Hello All, I have been trying to replicate excel Sumifs in Power BI without much luck. I have below excel data and a summarised table. The Table on the right in excel is essentially doing sumifs based on filter selection. For e.g. Sum of Volume for Customer =Cust 1, Product=Hat 1, Plan =A...

I have been able to connect data to excel using publically available APIs and Power Query. Stuff like data from this page and an API like the equivalent downloads for UTLA API. I get data from a Power BI dashboard but they don't have a publically available API like the data above but copying...

I am working on a dashboard and I am showing a box with Previous year data. Below is what I have come up with, however I am getting either an error message. or a message of no data. The data I am testing definitely has data. If I input the year I want such as 'Date', 'Date'[Year] = 2020 it will...

I have been searching for a way to connect an Access database TO a Power BI dataset and have literally found nothing regarding it. All I find is the other way around which I do not want. Is this even possible? Please and thank you. ~ Ky

Hi there, I am currently using the following two measures with a power pivot table: Sales Count =DISTINCTCOUNT(SalesHistory[Transaction ID]) Sales Frequency (return a “2” if there are at least 3 sales instances, “1” if instances of sales is between 1-3, “0” if no sale) =if([Sales...

I m a bit stuck which way to go or which course to choose to resolve the following issue. I have a table of 1500+events in 30+topics The events took place all around the globe in the past 3years. Events were lasting 1-5 days. Locations were fixed. This system is not sustainable. So I m asked...

Hi, I'm trying to filter the duplicates in the column "TYPE" to show the ones which are having the "NR" of 2 and another number. In this example that would be the lines 2,3 and 4,5 because the lines are duplicates in the TYPE column and have the NR "2" and one or more other numbers in the NR...

Hi all, I'm attempting to do a simple 12-month turnover rate: Employee Separations / Avg Employee Headcount over 12 months However, the dataset I have has employees appearing multiple times as they are split over multiple roles. Initially, to overcome this issue for getting my rolling...

I know next to nothing about Power Automate so forgive me if it's very simple. I have to download certain files from a power BI dashboard (like using the export to part) and save them to a certain folder. Is there a way to use the browser version of Power Automate to download files and save them...

So I am trying to connect a premium Power BI dataset to excel using this guide. It however is not working. When I connect the dataset using this guide, it works until I get to the pivot table option and says "The field you are moving cannot be placed in that area of the report". What do i do to...