dax

Can someone help with addcolumns, I have SUMMARIZE; EVALUATE SUMMARIZE ( Table1, Table1[Date], Table1[Item], "JA", CALCULATE ( SUM ( Table1[Units] ), ALL ( Table1 ) ), "RA", SUM ( Table1[Units] ) ) but want to use ADDCOLUMNS, so, EVALUATE ADDCOLUMNS ( VALUES (...

I'm looking for a better way to calculate control limits for an SPC chart in PowerPivot. I can do it with a small amount of data (~100 rows), however it is very inefficient and slow when doing it on a larger data set =(1000s of rows). The formula to calculate the control limits is: Mean ± Mean...

hi I have a table as below: I would like to create a column and find 1st break, 2nd break, and lunch. if an agent on the same day, the aux name is Break and Duration is larger than 600. the first break will be the Break1, the second break will be the Break2. if an agent on the same day, the...

Hi all, What is the best approach to create a waterfall like this in powerbi? I have no issues preparing it in excel but it won't load in powerbi. Glad to get advise. Data included below; Area/Goal Original Save Spend 2020 Targets 64.0 2021 Target 58.8 Train...

HI, I wanted to create a number sequence with dax , so started with ; Onevalue:=IF( HASONEVALUE(Table1[Date]),VALUES(Table1[Date])) I then used this in another measure ; Index := CALCULATE ( COUNTROWS ( Table1 ), FILTER ( ALL ( Table1 ), ISONORAFTER ( Table1[Date], [Onevalue]...

Hi, I'm having difficulty writing a measure that will for each month only pull through actuals values if there are any actuals values otherwise it should pull through the forecast values. So say a company is 4 months through its Fiscal Year it would show 4 months of actuals then the 8 months of...

In PowerBI I am calculating the percentage of productivity of each of the technicians who attend tickets, to calculate the productivity of each one I am using the formula "Tickets attended * 100 / Total tickets", to calculate productivity I am creating a new measure where I am executing the...

Hi Guys, I have an issue which seems to be easy but it's DAX so it isn't :-) I have similar Table (called "Data") as source: Added Table to data model then inserted a Power Pivot: count values in column "C" per Date and per Country: I started to get proper values for previous date but...

Hi, I'm trying to create a DAX formula to figure out the current QUARTER. Below are a few of my attempts. Our year starts Feb 1 to Jan 31. =if(dCalendar[DATES]<today(),if(ROUNDUP(MONTH(TODAY())/3, 0)=dCalendar[QTR],"CURRENT QTD",""),"") QTR =if(ROUNDUP((MONTH(TODAY())-1)/3, 0)=0,4) So...

I've attached a snapshot of my data - I'm looking to count how many shipping addresses a Partner ID has in a list of various Partner IDs. In the image the power BI formula I need is: - For Partner ID# PUS00000111 to show it has 14 'TRUE' shipping address values - For Partner ID# PUS00000342 to...

Hi, I've been trying to use topn to get the Nth hightest, selling item, I've tried ; EVALUATE TOPN(4,VALUES( Table1[Item]) ,[totalUnits] ) and then thought to wrap this in a MINX to get the 4th top Item,, MINX( TOPN(4,VALUES( Table1[Item]) ,[totalU] ), Table1[Item] )...

Hi, I am trying to create a power pivot measure that sums with two filters and have tried a variety of ways and it will not work for some reason. There is something simple or obvious that I am missing and guidance would be appreciated. Example attempts below This code works CALCULATE(SUM('09...

Hi Peers, Need your guidance if possible. I have searched formums and google and cannot find a solution I dont know if this is even possible: I have the following code which works on a windows operating system. Which was taken from this site...

Hi, Can some one tell me the difference, this is from MS DOCs for DAX, don't both clauses mean the same? "If the sort order is ascending, the comparison to be done is first parameter greater than the second parameter. If the sort order is descending, the comparison to be done is second...

Hi, I have the following workbook to get weighted student grade averages, which I am doing with `SUMX()` in DAX (From what I understand, this is akin to `SUMPRODUCT()` in Power Pivot): =SUMX(grades, [grade] * RELATED(weights[weight])) It's working pretty much as I want, except for the Grand...

Hi, Cross posted Excel Forum ; https://www.excelforum.com/office-365/1399068-dax-filtering-between-dates-with-keepfilter.html#post5787380https://www.excelforum.com/office-365/1399068-dax-filtering-between-dates-with-keepfilter.html#post5787380 Can someone help with this I have...

Good day, I have the following table and I need to reallocate the amounts for Site 1 to all the other Sites, based on the percentage of total amount that each of the other sites have against the total revenue excluding Site 1. To illustrate, the data, which comes from a pivottable: Sum of...

Hi, I'd like to write a measure to calculate the sum of the current and previous month totals, so Sum dec ; january, Sum January Febuary, Feb : March, in a nonth month ( Date) scenario I've used the the following; SPC:= VAR oneV = IF(HASONEVALUE(Table1[Date]),VALUES(Table1[Date])) VAR...

Hi, I have many tables and I would like to find out the best way to count the number of units sold that meet a criteria. In tblInvMaster I have a fields called PROMO CODE. I want to sum up the number of units from tblSALE that have a PROMO CODE. So I can use the related function in DAX...

I'm working with some data Where I have a branch, clients in a branch and products with that client. I've managed to get the values in a pivot from measures at product level provided I filter on a client. A soon as clear the client filter all the values become incorrect. Ideally I want to...