measure

  1. G

    Power BI - Changing Value For Reports Based on Month/Year

    Hi Everyone, In example below we see John Doe recently changed managers. We know John changed managers on March 1st of this year. Normally the easiest way to input this change would be to simply go into our excel file that is being used as the source for the dataflow and change the manager’s...
  2. A

    Measure prevents fields from being selected, and viceversa.

    Hi. I have a weird problem. If I add a measure to the values, it prevents me from selecting fields. If I add fields, Excel will not allow me to add the measure to values. And the weirdest thing is that it was working, and then said the original pivot table could not connect and became unusable...
  3. N

    Return List of Customers only if Slicer Conditions are Met

    I am NEW to Power BI and DAX. I am trying to write a measure and place it in a matrix that filters a list of customers based upon selected dates within a slicer (a customer must be a customer in ALL dates selected). For example, if I have five customers, and I select the dates 01/01/2020...
  4. S

    How to look up first discount in a related table.

    Hi, I'm looking for a way to look up the first time an item was marked down. I have a table with OH HISTORICAL, that has what our OH was each date historically. Then I want to look at what the discount was at that time in the related table. The item will be discounted many times over the...
  5. G

    Daily average of previous 5 Years / Problem with leap year

    Hello everybody! As a newbie, I'm approaching Power Query and Power Pivot. After the initial successes, I am now stuck with a problem and hope for expert advice. I've already added my data to the Power Pivot data model. Date StorageLevel 01/01/2015 165.31 01/02/2015 164.98...
  6. R

    Excel Power Pivot with 2 measures in Value column

    I have an excel Power Pivot, using measures. Here is what the current output looks like. The server column is the result of a measure using a concatenatex function: Note that the Servers exist within a Group, and that each App defined in a Group are all on the same set of Servers. To avoid...
  7. L

    Filtering a Calculated Measure From Another Table

    Hi All, My brain is fried again. I have scenario where I have to calculate various stats between two sets of data. The only thing common between the two data sets are the Calendar Weeks and the Supplier Numbers. So I have two tables: Table 1 has all of the supplier claims quantities by...
  8. M

    Compare and count similarities 2 measures

    Hi Guys, I cant get this done and some help would be awesome. I've got 2 measures. 1st measure calculates count of ID's based on certain filters 2nd measure does the same I want to know if there are same ID's in both measures and count the similarities. I already tried to do something...
  9. C

    DAX Subtotals Profit and Loss statement

    I'm using the following method from Imke to produce a nicely formatted pivot table in Excel: https://www.thebiccountant.com/2016/07/21/easy-profit-loss-account-scheme-reports-power-bi-power-pivot-dax/ However, I am building on this to produce projected numbers. For each reporting heading the...
  10. N

    Dynamic slicer

    I wish to create a measure, so I can dynamically populate a slicer, but the slicers don't accept a measure as input, so I don't know what to do. Any help will be greatly appreciated. Thanks.
  11. S

    Refresh just one DAX measure based on a cell change

    Hello all, I'm looking for a way to refresh a DAX measure not the whole workbook. When I change a value in a cell. So if I change let's say the date in a cell I want a specific measure to be updated. Otherwise refreshing the whole workbook takes may staff 20 minutes. When I can go direct to...
  12. S

    DAX measure produces more than TOP 15. Slicer issue?

    Hi, I'm having an issue with a DAX formula limited to TOP!%. But produces more that 15 lines. Could it be because I have a filter on the PIVOT TABLE for location. But need to add it to the measure? tblLocation.Loc# The measure below should provide me with the TOP 15 Brands sold for the day...
  13. S

    "Add Measure" Isn't Coming Up (even after I select "Add Data to Data Model")

    I am trying to have texts in a value field in a pivot table, and my understanding is that creating a Measure (concatenating the text) is the best way to do so. However, I am unable to create a measure when I am in the Pivot Table, as even after I select "Add Data to Data Model" when creating the...
  14. B

    Convert DAX Calculated Column to a Measure

    Trying to convert a DAX Calculated Column to a Measure with no luck. Any ideas? See below and attached. Thanks. =CALCULATE ( DISTINCTCOUNT ( Table1[Patient ID] ), FILTER ( Table1, Table1[TotalTime] > Legend[Start] && Table1[TotalTime] <= Legend[End] ) )...
  15. C

    Measure formula to count upcoming days

    Hello there. I found a measure formula to display only dates before today. Is there a way to count only dates occurring in the next 30 days? The first formula was added a measure to a visualization so i suspect I would need to add another measure to the same visualization to show the next 30...
  16. O

    Pivot Table Calculated Fields

    My source data is in Power Pivot, pulled directly via SQL, and I have measures that calculate over 20 days, 10 - 20 days or under 10 days. These are based on a calculated column that categorises each line accordingly (from a Task age column). I want to create a pivot table that shows max task...
  17. E

    Change Data Structure

    Hello, I was looking to do a Power Bi but the excel file that I am using has data in an unfriendly way for Power Bi Current data structure <tbody> 2014 2015 2016 Measure #1 1 2 3 Measure #2 2 4 6 Measure #3 3 6 9 </tbody> Desired Structure <tbody> Year...
  18. D

    Equivalent of DATESBETWEEN(LASTDATE... ?

    This query pertains to Power Pivot in Excel 2016. I have a table containing every annual contract, past and present, which includes contract end dates and amounts. (I also have two separate related tables, one for client and one for calendar.) I'm trying to write a measure for a pivot table...
  19. W

    Subtotals show grand total

    Trying to create a measure that an end user could grab and not have to worry about filtering to get the numbers narrowed down appropriately. Sum of gl transactions measure below. Works, but end users would have to know how to manipulate the filters on Acct Fin Class Code, Acct Prop Class...
  20. A

    Calculating with measure in calculated column

    I have prepared a measure that returns a certain rate determined to be calculated only within a certain part. But then when I call this measure, only blank is returned, even though the measure shows a number. I have prepared a condensed example Power Pivot model that explains what needs to be...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top