1. D

    DAX AverageX

    Hi, I'm having a problem understanding what I'm doing wrong; I have a measure for Revenue; < SUMX(fTransactions, fTransactions[UnitsSold]*(1- fTransactions[Discount])*RELATED(dProduct[RetailPrice]) )...
  2. D

    Power bi measure

    Hello, I've been writing a few measures for power pivot, but am trying to get more familiar with the bi environment, and I don't know if I'm being really sturpid, but how do I look at the syntax for a measure already created in power bi, in pivot I just go to power pivot manage, and there they...
  3. Z

    Calculate the attrition for new hired (<= 6 months of hired date)

    Hi, I need to calculate the voluntary attrition for employees who left the company within less than or equal to 6 months of their hire date. How would I accomplish this? I have below fields and tables: - Attrition Table that has below fields: - Employee ID - Hire Date - Term Date - Term...
  4. C

    Comparing fact table value to an earlier value in same table

    I am trying to create a measure that will show how many members our group has gained or lost since our last month. The data source is a spreadsheet exported from our membership software once a month, with rows for member ID, member status, and a couple of other columns. I have transformed that...
  5. M

    Doing SUMIFS in Power BI

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

    DAX Help - Latest Value

    Hi I am looking for help with a DAX Measure. I have a list of milestones that might change each month. I am looking to do two things. - Return the latest status value of the milestone, - Count the number that match that status value, many are now Green, Amber, etc. My data looks a...
  7. S

    Help with a cross tables measures

    Hi Guys, I have a corporate powerbi with a size limit, so I want to create a measure and not add another column to take up space. I have 3 tables MasterData, CBO (custoemer Backorders) & OnOrder (Supplier on order( all tables are linked to the Masterdata as the primary link and there are no...
  8. T

    Using Filter (or similar) with ConcatenateEx on Text Values

    I have the following dax measure in the value area of a pivot table to return a concatenated list of unique values from a table: =CONCATENATEX( Values( Table1[Column2] ), Table1[Column2],", " ) There are instances where 0 is returned as the value because no corresponding values...
  9. tbablue

    PowerPivot - New measure - calculate based on two criteria

    Hi Forum, Quite straightforward I'm sure - but I'm new to measures in PowerPivot. I have three columns; Definitive Name, Yr.Mnth & Employee FTE. The table name is 'Summary Query'. I need a measure that will calculate Employee FTE based on the number of times that 'Definitive Name' appears in...
  10. F

    Calculated measure in Pivot Table

    Hi! I´ve been trying to get a measure in my pivot table to get the % of reject orders of a partner / Total order order of partner, and that it can change if I use a slicer to change it by day, month, etc. This is an example of the data table which I use: And this is the pivot table which I...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. C

    DAX Subtotals Profit and Loss statement

    I'm using the following method from Imke to produce a nicely formatted pivot table in Excel: However, I am building on this to produce projected numbers. For each reporting heading the...
  20. 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.
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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