No announcements

### DAX - last occurrence in a month

multiple instances for one month. how can I find the last occurrence of all the accounts in a month (and then summarize all of these ...
| 8 Replies | 1239 Views | Created by yaniv012 - Wednesday, May 27, 2015 7:06 AM | Last reply by yaniv012 - Tuesday, June 9, 2015 7:59 AM

### DAX: Max date last month

Hello, I need to find sales amount of the max day on the previous month in DAX. The date can be ...
| 1 Replies | 3751 Views | Created by Sasha R - Thursday, March 20, 2014 1:05 PM | Last reply by Olaf Helper - Thursday, March 20, 2014 1:29 PM

### Last Month-to-Last-Child

Assuming that all days in a month till the last day with data should be included, something ...
| 1 Replies | 6290 Views | Created by Lamkap - Monday, May 7, 2007 8:10 AM | Last reply by Deepak Puri - Wednesday, May 9, 2007 5:56 AM

### How to find the precent of one of last occurrence Compared to all last-occurrences (dax) ?

Hi Yaniv, According to your description, you need to get the precent of one of last occurrence Compared  to all last-occurrences, ...
| 10 Replies | 1358 Views | Created by yaniv012 - Wednesday, June 3, 2015 12:49 PM | Last reply by yaniv012 - Thursday, June 18, 2015 12:30 PM

### Dax query to retreive the last bank date previous month

Hi I have been struggeling with just what I think a simple thing like getting the last bankday date last month. I have ...
| 2 Replies | 608 Views | Created by Mike 3 - Thursday, October 4, 2018 6:27 PM | Last reply by Mike 3 - Friday, November 9, 2018 3:46 PM

### Get last year's last month in MDX?

Quarter->Month 1) Use the below MDX to get the last month of last year if you drop the Year on the rows (Eg: 2009 on rows, then it will give Dec
| 2 Replies | 6091 Views | Created by wryatt - Wednesday, April 7, 2010 3:01 PM | Last reply by wryatt - Saturday, April 10, 2010 7:31 PM

### Finding last occurrence of a space in a string

Hello, I need to write a script where I can find the last occurrence of a space in a particular column. I figured out how to ...
| 7 Replies | 35804 Views | Created by DaveDB - Tuesday, February 9, 2010 9:13 PM | Last reply by AlunJ - Wednesday, February 10, 2010 3:20 PM

### Last day of a month

User165950705 posted To get the last day in a month from a datetime value is not too hard either but you need to do a little ...
| 6 Replies | 19 Views | Created by Anonymous - Tuesday, June 1, 2010 10:47 AM | Last reply by Anonymous - Tuesday, June 1, 2010 11:52 AM

### Return last date in month

(date); // Get the last day of that month var targetDate = new Date(currentDate.getFullYear(), currentDate.getMonth() + 1, 0); return ...
| 2 Replies | 22 Views | Created by Anonymous - Friday, October 10, 2014 1:18 PM | Last reply by Anonymous - Friday, October 10, 2014 2:31 PM

### Expression SSIS last month

Hi jawehe89, Instead of getdate() you need the last month everywhere via DATEADD This works on my ...
| 1 Replies | 435 Views | Created by jaweher89 - Thursday, March 15, 2018 2:53 PM | Last reply by ArthurZ - Thursday, March 15, 2018 3:12 PM

### First & Last satarday in Month

hi i am developing payroll system C# vs 2008 n Sql 2005 . in my company some employee get weekly off 1st  and ...
| 4 Replies | 6861 Views | Created by naweez - Monday, January 3, 2011 7:13 AM | Last reply by Leo Liu - MSFT - Wednesday, January 5, 2011 10:36 AM

### last monday of month

Hi, Calculate the number of days in a month, then loop backwards (for efficiency) checking DayOfWeek: static DateTime? ...
| 5 Replies | 7080 Views | Created by arkiboys - Wednesday, June 6, 2012 8:12 AM | Last reply by OmegaMan - Wednesday, June 6, 2012 2:28 PM

### last sunday of month

; } } alert("The Last Sunday in the month '" + Months[month-1] + ...
| 10 Replies | 35 Views | Created by Anonymous - Tuesday, April 13, 2010 5:53 AM | Last reply by Anonymous - Friday, April 30, 2010 9:03 AM

### Last 6 month dimension

month data, right? As Ananda said, you can achieve it by "add an attribute to your "Date" dimension and use the attribute as a slicer in Power ...
| 3 Replies | 1430 Views | Created by Youdhbir - Saturday, January 11, 2014 9:21 AM | Last reply by Youdhbir - Wednesday, January 15, 2014 7:55 AM

### SSAS DAX formula for same period last year not same month last year

The DAX function sameperiodlastyear, only works if the period we are interested in, is the same as a month. However our Period 3 for 2014 was ...
| 6 Replies | 4217 Views | Created by SOTN - Monday, January 5, 2015 1:28 PM | Last reply by SOTN - Tuesday, January 6, 2015 9:55 AM

### last day of month

If you want to get last day of a month, get first day of the next month and subtract 1 day. However, if you want to use first and last days in ...
| 8 Replies | 6872 Views | Created by WIJ - Wednesday, February 16, 2011 8:00 PM | Last reply by malthinus - Tuesday, February 22, 2011 8:30 AM

### Last month Data report

i have a table where lot of data month wise . I just need only last month data record .  what is possible Query for this .?
| 6 Replies | 747 Views | Created by ss_ssa - Monday, October 3, 2016 10:35 AM | Last reply by Sam Zha - Tuesday, October 4, 2016 7:24 AM

### today -2 month & last of that month

, Date.Today.Month)) This create a date object with the last day of current month. You can change the Date.Today to other date object so that it can serve ...
| 3 Replies | 4338 Views | Created by alex121 - Tuesday, June 13, 2006 7:45 AM | Last reply by cwlaualex - Tuesday, June 13, 2006 9:37 AM