Welcome in Dinesh Patel Blog

SUM(     LastPeriods(         3,         PARALLELPERIOD(             [Date].[CalenderHierarchy].[Month],             1,    Ancestor(                 [Date].[CalenderHierarchy].CURRENTMEMBER                ,[Date].[CalenderHierarchy].[Month]             )         )     )     ,[Measures].[Count] )

SUM(     PARALLELPERIOD(         [Date].[CalenderHierarchy].[Month],         1, Ancestor(             [Date].[CalenderHierarchy].CURRENTMEMBER            ,[Date].[CalenderHierarchy].[Month]         )     ),     [Measures].[Count] )

DAX Functions for YTD and MTD: =TOTALYTD(SUM(Finance[Amount]),Time[FullDateAlternateKey]) = Current_Year_YTD =TOTALYTD(SUM(Finance[Amount]),PARALLELPERIOD(Time[FullDateAlternateKey],-1,year)) = Last_Year_YTD =TOTALMTD(SUM(Finance[Amount]),Time[FullDateAlternateKey]) = Current_Year_MTD =TOTALMTD(SUM(Finance[Amount]),PARALLELPERIOD(Time[FullDateAlternateKey],-1,year)) = Last_Year_MTD =CLOSINGBALANCEYEAR(SUM(Finance[Amount]),Time[FullDateAlternateKey]) = Full_Year =CLOSINGBALANCEYEAR(SUM(Finance[Amount]),PARALLELPERIOD(Time[FullDateAlternateKey],-1,year)) = Previous_Year_Full =CLOSINGBALANCEMONTH(SUM(Finance[Amount]),Time[FullDateAlternateKey]) = Current_Month_Full =CLOSINGBALANCEMONTH(SUM(Finance[Amount]),PARALLELPERIOD(Time[FullDateAlternateKey],-1,month)) = Previous_Month_Full =CLOSINGBALANCEMONTH(SUM(Finance[Amount]),PARALLELPERIOD(Time[FullDateAlternateKey],-1,year)) = Last_Year_Current_Month_Full =CLOSINGBALANCEMONTH(SUM(Finance[Amount]),PARALLELPERIOD(Time[FullD...

http://msdn.microsoft.com/en-us/office/dn448488

What is Big Data? Big data refers to huge data sets that are orders of magnitude larger (volume); more diverse, including structured, semistructured, and unstructured data (varity); and arriving faster (velocity) than you or your organization has had to deal with before. This flood of data is generated by connected devices - from PCs and smart phones to sensors such as RFID readers and traffic cams. Plus, its' heterogeneous and comes in many formats, including text, document, image, video, and more. More:  http://www.intel.com/content/dam/www/public/us/en/documents/guides/getting-started-with-hadoop-planning-guide.pdf

http://www.juicingbook.com/fruits http://www.juicingbook.com/vegetables

Mobile BI http://www.mobiweave.com/#/bi