power bi

Hi I have the table attached and I want to have the output table attached. Power BI has to get the last owned vehicle by person and then get when it was owned.

Hello Experts, I have been struggling for hours with different variations of this DAX formula in Power BI: Rank Shops = CALCULATE( RANKX( ALL(PDB[RM]), CALCULATE(AVERAGE(Shops[Report Total])), , ASC, Skip ), PDB[Simplified Portfolio] = "Stable" )...

I have these two datasets that I want to link together. Dataset 1 contains column units sales by specific EAN and Etailer in a specific week. Dataset 2 contains customer ( = etailer), SAP sku (=EAN) and month (=actually week data as is dataset 1), unit sales sell in. I want to combine this to...

Hi, I've managed to make a dynamic ranking with a custom TopN filter, output is a table with brands ranked by TopN filter and the rest is always summed up by a total under "Others". This is because there are several subcategories. So within a subcategory the dynamic filter is working on...

Help! I’m looking make a formula/conditional formatting to highlight a blank cell if there is data in the cell before or after. I must select hundreds of blank cells, so it doesn’t help when they all highlight. thank you!

Hi guys, I have a rolling calendar in PowerBI combined wih Transaction data. I have created a measure calculating LTM revenue: Revenue Netto LTM = CALCULATE([Revenue_Netto],DATESINPERIOD(Dates_Lookup[Date],MAX(Dates_Lookup[Date]),-12,MONTH)) The calculation is not very accurate though and I...

Hi I am building a dashboard for survey data and for reasons I am not quite sure I am running into a couple of problems. I have five questions that I want to focus on. My dashboard looks like so: 1) I wrapped the text box at the top with a blank box that i removed the borders. When I...

Hello, I have data on about 100 companies that is fed by a SharePoint list that has versions turned on. Over time, the SharePoint list is updated with new information. For example, as the number of employees changes, it gets updated. What I'd like to do is add a date slicer so a user can...

Hello, Looking for some guidance as I am a complete newb when it comes to PowerBI and Power Query..... Here is my dilemma I have a workbook that has 50 (US states) sheets plus 4 summary sheets I have written (with the help from Joe & Fluff) VBA macro that goes and looks at the cell color If...

I'm trying to create a measure which will incrementally subtract demand from supply based on rank. The ranks are already assigned and exist in the data (e.g., 0-100). Is there a way to do that in Power BI? My target end state is a matrix visual that shows each product and it's rank on the...

My organization has a report of the cumulative net income for each quarter for each year. I need produce a report in Power BI that pulls the quarterly net income rather than the cumulative net income. I currently have three DAX measures, one that pulls the current cumulative net income, a...

Hi, in power pivot I can declare a variable ; VAR name = TableName[Column Name] But when I've tried doing this in power bi I am unable to do this, e.g in the measure below I wanted to put a variable for a Table Column but am unable to do this, , can anyone explain why and who to get around...

Hi, Can someone tell me if Powe pivot and Power Bi work differently in relation to date / Calendar Tables, So if I have a meaure ; SUM(TslaesTable[Sales} ) and I use this in a pivot table which is just has Dates in the Rows, if i use the dates from the sales table I get what I would...

I have two queries where i can merge them with the "ID". The phase query has the phase ID, and the phase start and end date. The other query has hour values and a date value, and i want to add a column to this query with the Phase name, depending on which phase date range the date value is in...

Hi I have a table like this: I would like to convert it to scatter chart like this: I use Power BI, and put dates on x Axis and time on values or Legend. It always shows errors. I tried to put interval on y Axis, but it wouldn't move. can someone teach me how to create this chart? Thanks,

Hi, This is going to be a bit vague, I had a matrix containing Month and date from 'calendar table' and when I dropped the total sales measure into value it was flited down to one row showing the grand total. I tried to replicate the situation but haven't been able to do so. I'd copied the...

a task I've been set as part of a PowerPivot creation 1.Enter the last rep to have sold to the customer URN on the query tab of the PowerPivot. Now there's no query tab for me on powerpivot and as far as i'm aware query was part of a ribbon thats now get and transform which has nothing to do...

Is there a way of putting the date column into a matrix that is not a hierarchy, I can do this using the date column from the fact table, but would prefer to use calendar table as I've gone to the trouble of making it, essentially the left , which uses the calendar table to look a bit more like...

Hi, I have a running total in power bi, one using the date column of 'sales' and the other using the Calendar table, I'd like to use the calendar table but because it has every date I get date repeated where there is no current data, I'd like the matrix on the right to filter down to just...

Hi. Hope someone can tell if this is possible in Power BI. I like to make a map as illustrated (see attached picture) - either as a map or satellite. It´s important that I can see where the green shapes is located (city/roads) Is it possible to make shapes like this in Power BI? I thought...