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...
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...
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...
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...
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.
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...
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...
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...
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...
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...
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?
The measure below should provide me with the TOP 15 Brands sold for the day...
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...
Trying to convert a DAX Calculated Column to a Measure with no luck. Any ideas? See below and attached. Thanks.
DISTINCTCOUNT ( Table1[Patient ID] ),
Table1[TotalTime] > Legend[Start]
&& Table1[TotalTime] <= Legend[End]
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...
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...
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
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...
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...
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...