DAX - Time Intelligence - Previous Year, Same week, Same day of week

in the previous year in the same week and same day of week. Example 2017-01-10 ...
| 6 Replies | 5955 Views | Created by JohanMachielse - Sunday, January 8, 2017 7:27 PM | Last reply by SK_DavidMoss - Wednesday, January 3, 2018 1:04 PM

MDX Same day of week last year

query for calculating and comparing today with the same day of the week for last year and the previous year. We have a large data warehouse that ...
| 3 Replies | 7997 Views | Created by DrewCh555 - Thursday, January 17, 2013 2:17 PM | Last reply by RichardLees - Sunday, January 20, 2013 11:47 PM

Calendar week - previous week , last year week

that gives last year week number ,previous week number. for example if this week number is 5 , then ...
| 5 Replies | 2758 Views | Created by vamz9 - Wednesday, December 19, 2012 3:16 AM | Last reply by --CELKO-- - Thursday, December 20, 2012 3:08 AM

DAX query to calculate previous week to current week

previous week first. Please see my sample DAX below: previous = CALCULATE(max(tab[currentweek]), ...
| 1 Replies | 1641 Views | Created by Gugan.t - Monday, January 16, 2017 7:36 PM | Last reply by willson yuan - Wednesday, January 18, 2017 1:45 AM

DAX Expression to get Previous Week

Hi ScorpioAX, In DAX, there's no build-in PREVIOUSWEEK() function. To get the previous week total, you must have Year, Week Number ...
| 2 Replies | 6853 Views | Created by ScorpioAX - Friday, July 28, 2017 7:37 PM | Last reply by paeore - Monday, February 17, 2020 4:09 PM

YEAR --WEEK of the YEAR -- DAY of the WEEK to datetime

AS INT) SELECT DATEADD (WK,@week - 1,DATEADD(YY,@year-1900, 0)) - 6 + @day   Abdallah El-Chal, PMP, ITIL, ...
| 8 Replies | 5240 Views | Created by David Hills - Friday, September 17, 2010 4:18 PM | Last reply by --CELKO-- - Friday, September 17, 2010 8:06 PM

Cumulative Sales for a week for the previous year

] as ([Financial Time].[Week Start].members.Item([Financial Time].[Week Start].members.count-1),[Measures].[Net Value]) How ...
| 4 Replies | 3086 Views | Created by Kennilove - Tuesday, August 9, 2011 3:58 PM | Last reply by Kennilove - Wednesday, August 10, 2011 12:03 PM

Cumulative total for current week days and previous week

and the aim of the chart is to see the current week compares against the previous week for the same day.  I ...
| 3 Replies | 1458 Views | Created by Maracles - Monday, November 30, 2015 3:48 PM | Last reply by greggyb - Tuesday, December 1, 2015 11:51 PM

DAX/PowerPivot - How filter for previous week?

What is the DAX Function to report on just the previous week.  Mon-Friday, not 7 days prior to today. I see there are a lot of ...
| 1 Replies | 6441 Views | Created by blumm1 - Wednesday, August 15, 2012 6:22 PM | Last reply by blumm1 - Wednesday, August 15, 2012 7:41 PM

Create Time dimension Year, Week, day problem

Hi, I have a problem when creation a Time dimension Year, Week, day , The week does not start on the correct date eg. ...
| 12 Replies | 8697 Views | Created by Morten Rasmussen - Thursday, January 11, 2007 2:34 PM | Last reply by Thomas Ivarsson - Monday, January 15, 2007 9:52 PM

Getting data from a week and also that same week in previous months.

will want data from the similar week in previous months.  right now im getting the current week of the month so this week in my ...
| 7 Replies | 1315 Views | Created by vqcheese - Thursday, September 5, 2013 8:05 PM | Last reply by SQLZealots - Wednesday, January 29, 2014 1:20 PM

A week this year Against a week this time last year in SQL (NOT MDX)

in comparison to the same week in  previous year such that a given parameter would calculate for users the sells for previous week and ...
| 8 Replies | 8096 Views | Created by Yookos - Wednesday, November 20, 2013 8:08 AM | Last reply by --CELKO-- - Wednesday, November 20, 2013 3:07 PM

Year, Quarter, Month, Week, Day

How would I get the Year, Quarter, Month, Week and Day for any given date? I am looking for the actual Month and Day names rather than just 1 for January ...
| 2 Replies | 5956 Views | Created by mike950 - Wednesday, April 15, 2009 10:25 AM | Last reply by Chandra _M - Wednesday, April 15, 2009 10:45 AM

Time Intelligence Week calculation is incorrect

I'm having an issue with using the time intelligence week attribute when creating a filter in performance point.  The Year, Quarter, Month, etc all work ...
| 3 Replies | 802 Views | Created by JNF_Chad - Tuesday, November 26, 2013 1:46 PM | Last reply by Elvis Long - Friday, December 6, 2013 1:46 AM

SSAS MDX Calculations - Time intelligence puzzle. (53 week year)

Hi All, I've a question related to MDX calculations in SASS. I have a number of these set up perform various time intelligence queries, such as YTD, Week ...
| 7 Replies | 6479 Views | Created by GS80 - Tuesday, February 10, 2009 8:37 PM | Last reply by Martina White - Wednesday, February 15, 2012 7:57 PM

How to convert day into week of the year?

:00.000   0.000000 0.000000 P1   t4   2014-12-04 00:00:00.000   4.000000 0.000000 How to ...
| 3 Replies | 777 Views | Created by Julie Elizebeth Sam - Wednesday, January 14, 2015 3:00 PM | Last reply by BhanuSQL - Wednesday, January 14, 2015 4:14 PM

Same period previous year

is created by the time intelligence for YTD and others I don't know wat's wrong. I tried different things.  Is there any other way to calculate same period ...
| 1 Replies | 4136 Views | Created by sql sathi - Monday, April 6, 2009 3:18 AM | Last reply by DSU007 - Monday, April 6, 2009 5:34 AM

How to get this in ssrs reports "Filter Month defaults to the Month of the previous week and Filter Week and Day defaults to the previous week

to the Week of the previous week, and filter Day defaults to the Day of the previous week. In Reporting Service, we can use ...
| 7 Replies | 4053 Views | Created by NaveenMSBI - Tuesday, September 24, 2013 5:24 PM | Last reply by Mohan Kumar - CSA - Thursday, September 26, 2013 5:59 AM