measure

Hi there, Im looking for help to write the correct measure to pick the price based on the latest date and time. A simplified version of my data set looks like this : <tbody> ID Price Time 21 15,2 21.05.2019 10:00 21 15,9 21.05.2019 10:10 21 15,5 21.05.2019 10:20 21 14,7 20.05.2019...

I am trying to do something that should be simple, by my brain is having a dumb block. I have a table of sites showing their ranking for various performance measures. I just want to create a list showing which is their best and worst measures, but I'm getting confused where they may be the same...

Hi there, I'm sure there is a way of duplicating a userform. How do you do this? I just need to make three userforms, all EXACTLY alike. I don't want to take the time to measure it all out and place the buttons all the same. Thanks.

Hi, I am linking power pivot to a table of 220 million rows. I want to find the first time an ID appears in the data set. In doing so I would like to create a new measure by using the following formula: =N(countifs(Adrian_data[DeviceID],Adrian_data[DeviceID])=1)). The problem I am having is how...

Is there a finite number of measures that can be created in Powerpivot? I have numerous measures; after refreshing all; some measures disappear from the table fields. I've tried searching by name under the ALL tab. They are simply gone. I can see the measure in the Powerpivot Manage...

Hi All, I am using a disconnected copy of my Date table as a filter in a measure. The user selects a FinancialPeriod from the disconnected table and the measure is shown in a table with rows of FinancialPeriod from the original Date table. The purpose of the measure is a kind of 'Where are...

I have a date table that is standard. In my data table I have a list of 'ClosedDates' that does include blanks (maybe this is the issue?). When I filter this table manually I get the results I expect, a count of 380 rows. However, my measure is only calculating 363 rows. I went through the data...

Hi, I am struggling to return a result with a Dax formula. I have a Fact table that has some data Fact Table <tbody> Date Account Curr Trans Amt GBP Equiv USD Equiv 01/04/18 12345 EUR 10,000 9,000 14,000 01/05/18 12445 USD 15,000 10,000 15,000 01/10/18 12445 GBP 1,000 1,000 1,425...

Hi fellows! Background: I'm trying to do a dynamic top 5 customer based on the quantity of sales they've made. I created a measure Total_Sales using the "Qty" column of table "Sales". Important: the measure Total Sales will be part of the table "Sales". The argument "Sales[Total_Sales] does...

I have a measure that I *think* is returning what I want it to, but it's cumbersome and I'm wondering if there's a cleaner way to do this. First, here's the measure: Count of UoM Errors:= SUMX ( SUMMARIZE ( 'Match Exception', 'Match Exception'[ME_Key] ), CALCULATE ( MAXX (...

Hello and thank you in advance if you can help, I am using excel 2019 on a desktop, not Power Bi. I had posted this in the Power Bi section of this forum, but I think now, because I am not using power Bi but Power Pivot in excel 2019, I should have posted it here. I am trying to create a...

Hello and thank you in advance if you can help, I am using excel 2019 on a desktop, not Power Bi. I am trying to create a measure in power pivot that, despite repeated attempts, is not working. I have, in other scenarios, divided one measure by another to get a % I needed (or the decimal), but...

In PowerBI I am creating some personal spending metrics. One is an average cost per meal. I am trying to build a table the shows amount spent on grocery and an average $ per meal. I am struggling with a measure that calculates the days in a month that will be the denominator in the $ per...

I have a data model pivot table with a column named "2019 Actual" which shows sales amount. The column resides on the "CombinedAllYears" table. I don't technically have dates (4/1/2019, 4/2/2019, etc) in the table, just month names "Jan", "Feb" etc. I also have a "Store" slicer and want the...

Hello and thank you in advance if you can help, I am VERY new to using measures. I am using Excel 2019 on a PC. I have created some measures that will give me a distinct count of species in a query/dataset, as well as a distinct count of blocks. My data has fields/columns for All Regions...

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...

Hello guys, I have a matrix with some measure columns that creates some conditions. That´s the Delta_classification. Delta_classification =...

Hi, I have a lists of transports. The list contains for each transport the source (warehouse), the desutination (clientID) and the shipment date. Ultimately, I want to show in a 100% bar chart the share of clients that are being delivered daily, up to 4 times per week, up to x times per week...

I have a simple DAX measure in my Excel 2016 data model: [Who Am I Domain]:=USERNAME() When I enter this as a measure in the data model window and use autofill the end parentheses appear. However, after the measure calculates the parentheses disappear (which they don't do for...

I have a calendar table with a column WorkingDay that has a 1 for working days and 0 for weekends and holidays. A typical helper column to get business days would be: Business Days from Approval to Dispatch= CALCULATE ( SUMX ( Calendar, Calendar[WorkingDay]...