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...
Does anyone have any experience of applying formats to pivot table measures conditionally based on their name?
For example, if my measure has a (£) in its name, then apply a currency format, else apply a simple numeric format.
I've done this kind of thing successfully with ordinary pivot...
Hi, I just opened my Excel workbook and noticed all my DAX measures that were sorted into columns are now in a random order.
I've seen this before and moved them only to find them just thrown back into a random order.
Any thought how to sort them again and avoid this.
This seems like it should be an easy solution, but my brain is having a freeze. I have a dataset that only allows me to create measures. I need a DAX that would let me create a revenue field if the customer name begins with I/C. Any suggestions?
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...
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...
I am attempting to become more efficient with a process I do monthly by utilizing Power Pivot (which is new to me) verse excel and multiple formulas. All of my data is in one table and I'm attempting to replicate the formulas that have been created for use in excel for use in Power Pivot...
I am using Power Query and Power Pivot. I have a list of support tickets with dates opened and dates closed. I want a pivot table to count the number of tickets opened for a month and number of tickets closed for the month. When I create a slicer for each, it has to be two separate slicers. An...
I am starting to play with Power BI and am trying to do some conditional formatting on a matrix.
The measure that I have written works but has hard-coded values. The conditional formatting itself is being done on the measure using the rules of if value is 0 then colour white, if 1 then...
I have some data in the data model, and when I go into the measures to create a new one, the tables/columns etc are not pulling up as choices to use hen start typing them. I thought well maybe my query was broken so I physically copied the spreadsheet into the workbook and tried adding to the...
Hi, is it possible to create a pivot table based on the results of another pivot table.
I have an inventory table that has items and a measure that calculates slow movers and fast movers based on how many units are sold each week.
I then pull the information from the powerpivot table into a...
I'm looking for a best practice as to how to handle changing measures when your source data changes.
We're in a (continual) fact-finding mode with our data. The extracts from our various ERP systems are complex, such that the names and logic of columns can change as we slice 'n' dice and come...
In my current role I am using Excel 2010 with PowerPivot
One of the reports I produce is a tabular pivot table with one row for every row in the source table. Instead of dragging multiple columns into the row labels area, thus slowing an already slow environment, I am using measures to show the...
Per the title, I can see the added table in the Measure Edit window, and I can see it in the Power Pivot window, I can create a measure that accesses it's columns, but I can't see the table or the measure in the PivotTable Fields window, even if I select ALL.
Has anyone else seen this type of...
currently I work in excel, power pivot.
Here I have added a number of measures and calculated columns.
I would like to continue working in Power BI. If I load the current file via "get data", I only have the original data.
Is there a way to add the already-written measuers and...
I am relatively new to DAX and having issues arriving at a total for a measure. The measure is:
[Value] and [Factor] are two measures calculated in the model and work fine and trying to achieve Result by dividing one by the other. Result total shows...
I used disconnected slicers to choose from various measures for display. The individual measures can be percentages, currency, or regular numbers, so the "master" measure in the SWITCH function has a generic "General" format. It would be handy for the users to see the format matching the...
I am new to this DAX language and I am sure the solution isa very simple one, but I would appreciate some help.<o:p></o:p>
I have created two measures. <o:p></o:p>
MAX MONTH=MONTH(MAX('MONTHLYSALES 002'[Date]))
2016 ADJ NET SALES-YTD= CALCULATE(SUM([ADJUSTED NET SALES])...
I've been googling a lot before to post this question but I have not been able to find any answer.
I have a table named "TABLE" (say) and I defined a measure in it named "MEASURE".
Now, in another worksheet I can use a formula like this:
=SUMIFS(TABLE[Amount];TABLE[ID];10), where of...