I am trying to find the date when a person had their lowest score. I have tried something like this and it fails everytime that there are muliple answers:
View Complete Post
I need to reproduce the behaviour of the averageofchildren function with the exception that the function should always build the average of all members (even when the value of a member equals null). As you know average of children function always build the
average at the lowest level of the time dimension.
My date dimension looks like the following:
[Date].[Fiscal] user defined hierarchy:
if context of [Date].[Fiscal].CurrentMember corresponds to a Week, I can retrieve all weeks before the current week using
In Period: MTD([Date].[Fiscal].CurrentMember) -- PeriodsToDate also works fine
In Year: YTD([Date].[Fiscal].CurrentMember)
if context of [Date].[Fiscal].CurrentMember corresponds to a Period
How can I get all weeks (NOT Periods!) contained in all Periods before and within current period since start of year?
What would be a generic expression that retrieves all weeks before and in independently of level of selected Date dimension member
I have payment records that are in my table and need to update that table with the lastest pay date(non zero wgt) for all billnbrs that match.
I have billnbr,invnbr,line,payment,wgt,paydate fields defined in table. The payments with zero wgt are the ones needing updated they are like a surcharge but need to show the actual paydate for the entire billnbr.
What I would like to do is make the paydate for each billnbr(group by) reflect the true final payment which is the non zero wgt record. The table would look like this after update step.
var tecaji = (from xml in doc.Descendants(slazhnmaespace + "tecajnica")
where xml.Attribute("datum").Value == "2010-10-158"
select xml).Elements().Where(a => a.Attribute("oznaka").Value.Equals("TRY")).Select(n => n.Value).SingleOrDefault();
I have dates that are not in the XML file, but value still has to show.In the table there is no value for the date of 23.10.2010, 24.20.2010. How do you show value for the date 10/22/2010?Finding the appropriate date, which is najbluzjemu to that in the table.In this XML table is not displayed dates (Saturday - Sunday).Therefore, to find the nearest date before Saturday and Sunday.Example:If it is Saturday, the date "02.10.2010" shall be the date of "01/10/2010.How do I get to that solution?
I want to write select query ,the requirement is I have to find out date which is 3 days less than twenty fifth days of prior month
it start from 2010 .
Do you guys know it is possible to write select query ,I am writing query but not getting expected result .I am trying to do this in excel sheet also by writing excel program . please let me know.Thanks
I have Start date and accordingly find out end date
eg.if startdate=1/1/2010 then enddate=1/2/2010 for this use
NOw if startdate = 28/2/2010 the output shuold be 31/3/2010.how to do this?
Here enddate=startdate.AddMonths(1) gives o/p=28/3/2010 but i want o/p shuold 31/3/2010.
Thanks in advance.