No announcements

### Calculate sum of measure for multiple date range in DAX

Hello, Is there a way to calculate the sum of measures for multiple date ranges in DAX ...
| 1 Replies | 3450 Views | Created by mabilash - Wednesday, May 29, 2013 8:45 PM | Last reply by Ed Price - MSFT - Friday, October 25, 2013 9:02 PM

### DAX measure error (calculate)

Hi team, I write a dax measure in a data model as following: vs=calculate(sum(tablea[sales],all(tablea[brand ...
| 2 Replies | 656 Views | Created by Tom J Sun - Thursday, June 1, 2017 6:31 AM | Last reply by Tom J Sun - Thursday, June 1, 2017 11:36 AM

### MDX - Sum of measure for range 1 union sum of measure for range 2

the number of customers who has shipped in the date range. Please help me to solve this issue. Thank ...
| 4 Replies | 3041 Views | Created by subin3 - Wednesday, August 8, 2012 6:58 PM | Last reply by subin3 - Thursday, August 9, 2012 7:49 AM

### DAX DatesBetween Question (Finding SUM between a date range)

The assumption is that you use the measure in a query, such as a pivot table, where you filter data by using a range of values (one day/month/year) of ...
| 3 Replies | 2272 Views | Created by Vik2907 - Friday, January 29, 2016 9:58 PM | Last reply by Marco Russo - SQLBI - Monday, February 1, 2016 9:22 PM

### DAX / Measure - Date Parameters

the second formula, (in addition to lacking a measure), you're attempting to filter the table twice (once with FILTER and then with CALCULATE). Would ...
| 13 Replies | 12841 Views | Created by johncon - Friday, January 8, 2010 7:23 PM | Last reply by johncon - Friday, February 5, 2010 5:50 PM

### DAX to calculate SUM of distinct Ids

InvoiceId. I want to create a measure to SUM the InvoiceAmt but I want to consider distinct InvoiceId. I cannot do SUM on LINE_AMOUNT because data is not proper ...
| 4 Replies | 998 Views | Created by Aniruddha Thengadi - Monday, June 24, 2019 2:12 PM | Last reply by Aniruddha Thengadi - Wednesday, June 26, 2019 9:16 AM

### conditional sum in powerpivot measure (DAX)

Hello, forgive my ignorance but I'm more of a business guy than IT.  I'd like to create a DAX measure that looks at a text column and if it contains ...
| 2 Replies | 9559 Views | Created by JohnnyShakes - Monday, November 28, 2011 3:23 PM | Last reply by Challen Fu - Thursday, December 1, 2011 5:36 AM

### Calculate sum of product using DAX

Hi Everyone, Can anyone help me to create DAX formula for getting contribution numbers as per below image. Please see below explanation of each ...
| 2 Replies | 564 Views | Created by ManikantM - Wednesday, November 9, 2016 10:34 PM | Last reply by ManikantM - Saturday, November 12, 2016 10:24 AM

### DAX-Multiple Measures in Single Measure

Syntax Of course, we can. See below DAX Measures used in my test PBIX file: TotalSales = SUM ( Sales[Qty] ) YTD ...
| 8 Replies | 983 Views | Created by Rihan8585 - Sunday, July 22, 2018 4:08 PM | Last reply by Rihan8585 - Sunday, August 12, 2018 8:30 AM

### DAX Calculated Measure for Sum of Max values

pass as argument 1 (in this case the list of unique products) and accumulate the value of the expression provided in argument 2 evaluated for each row ...
| 3 Replies | 12477 Views | Created by Andy Kinnier - Monday, September 21, 2015 1:39 PM | Last reply by Kristin DAX - Thursday, August 25, 2016 2:36 PM

### DAX filter on Date Range

approaches similar to your filter expression to achieve the equivalent of an SQL "Between" join (see here
| 3 Replies | 989 Views | Created by SH_2017 - Thursday, November 23, 2017 11:13 AM | Last reply by SH_2017 - Friday, November 24, 2017 4:50 AM

### DAX Measure for Returning Students?

3rd is the slicer.  How do I write a dax measure to calculate the number of students who returned to a later academic period who were from a ...
| 1 Replies | 932 Views | Created by Ryan Smiths - Tuesday, October 28, 2014 12:15 PM | Last reply by Marco Russo - SQLBI - Tuesday, October 28, 2014 2:44 PM

### calculate over date range

the selected date filters. There is also a could of errors in your beginDate test measure. I've fixed those and added one for endDate ...
| 12 Replies | 907 Views | Created by Abdul527 - Wednesday, May 11, 2016 7:49 AM | Last reply by Abdul527 - Monday, June 13, 2016 8:07 PM

### DAX Sum of children

For example, in the image below, for the account *test* it gives Forecast Error 76450 total, but should return 482152 which is the sum of all the values on ...
| 5 Replies | 1882 Views | Created by Jan Van humbeek - Friday, April 11, 2014 1:11 PM | Last reply by Jan Van humbeek - Monday, April 14, 2014 8:13 AM

### DAX Formula to Calculate YTD Sum by Specific Dates

Hello Everyone, Can some one please help me with a DAX function that can provide sum of sales of this year, let's say from Jan 1, 2015 till ...
| 1 Replies | 747 Views | Created by ANExcel - Monday, October 19, 2015 2:11 PM | Last reply by Ed Price - MSFT - Friday, July 29, 2016 8:38 PM

### DAX sum of children

month and by year (in the code shown i made it blank) because I canno't aggregate the exchange rate by sum, averege (in the code the average function acts on one row..) and ...
| 5 Replies | 1313 Views | Created by Davide Becco - Monday, February 24, 2014 11:41 AM | Last reply by Davide Becco - Monday, February 24, 2014 5:20 PM

### DAX for creating sum of the percentages

measure for the day, which would be Sum of (%Forecast * %Weightage). In the example here it would be Sum (91*23.07 + 97*30.7 + 92*46.15)/100 = ...
| 1 Replies | 722 Views | Created by IndusCrest - Monday, February 23, 2015 8:25 PM | Last reply by Gerhard Brueckl - Tuesday, February 24, 2015 6:32 PM

### Calculated measure based on date range

year/month/week/day is used with another year/month/week/day in other words it must allow a combination of the date hierarchy and still use the last date ...
| 1 Replies | 2448 Views | Created by TPBurger - Wednesday, November 28, 2012 9:09 AM | Last reply by Martin Mason - Wednesday, November 28, 2012 4:55 PM