Week over Week Comparison

[phanimusunuri9]

Hi All,

I am trying to compare "Monday Last week's Sales" with "Monday this week's Sales". To be precise, if today is 'Monday' i want to compare it with last 'Monday', if 'Tuesday then last week 'Tuesday'. so on..

Sales last Monday = 2,450

Sales this Monday = 2,360

Difrerence = 90 (3.6%)

Is there a way to do this as a 'Measure', i want this in KPI visual.

[mase_53]

Hi @Ashish_Mathur @phanimusunuri9 @Anonymous @jcabeza is there a way to use this solution - when my Year, Week Number and Weekday columns live in another table (dim_dates) but have an active relationship with the date in the table containing sales? Would appreciate your help!

[Ashish_Mathur]

Hi,

Share some data, describe the question and show the expected result.

[Ashish_Mathur]

Hi,

Share a snapshot of your data.

[arpitsa]

Hi Ashish,

Can you please assist me in calculating last week vs current week comparison in power bi +-

[Ashish_Mathur]

Hi,

Share some data and show the expected result.  More importantly, in the Calendar table, please show a column with the week numbers.

[arpitsa]

Share your email id, i will share pbix with you 

[Ashish_Mathur]

Hi,

Upload the file to Google Drive and shre the download link here.  In the Calendar Table, please enusre that you have a week number column.

[arpitsa]

Hi Ashish,

i need rolling six week vs current week option in slicer and my week starts from friday to thursday 

it should exclude the current week and take respective weeks for rolling 6 weeks

Eg - i have data from Wk.1 to Wk.6 and wk.7 has only  4  days data and i am in 5th day so rolling 6 week would be Wk.1 (Friday) to Wk.6(Thursday) and current Week would have Wk.7 Friday till today-1

could you please assist me in getting this columns in power bi

[phanimusunuri9]

Hi All,

I am trying to compare "Monday Last week's Sales" with "Monday this week's Sales". To be precise, if today is 'Monday' i want to compare it with last 'Monday', if 'Tuesday then last week 'Tuesday'. so on..

Sales last Monday = 2,450

Sales this Monday = 2,360

Difrerence = 90 (3.6%)

Is there a way to do this as a 'Measure', i want this in KPI visual.

[v-sihou-msft · Accepted solution]

@phanimusunuri9

You should have Year, Week Number and Weekday columns in your table. Or you can generate with calculated column. 

WeekNumber = WEEKNUM(Table[Date],2)

WeekDay = WEEKDAY(Table[Date],2)

Then you can create a measure like: 

Difference =
SUM ( Table[Sales] )
    - CALCULATE (
        SUM ( Table[Sales] ),
        FILTER (
            ALL ( Table ),
            Table[Year] = MAX ( Table[Year] )
                && Table[WeekNumber]
                    = MAX ( Table[WeekNumber] ) - 1
                && Table[WeekDay] = MAX ( Table[WeekDay] )
        )
    )

Regards,

[Utsav_cpgio]

I have a large amount of data because of that i cant use this. can you help me how to compare without dax.

[chickadiva]

This works great! until I try to filter based on a category field.  Is there a way to add a dynamic filter so that this works for each "sales" category?

[rusgesig]

I've been looking for for so long, thanks.

[Anonymous]

Hi Guys,

I am trying to calculate the week by week comparison of the total Number of Jobs from Previous week to current week & % change.

 I have Year, Week num, Num of jobs from the Data set, what measure do i use here?

i tried to use the above measure, but did not work for me as it is $ Sales & on my report i do not require $sales.

thanks for your help here.

[jcabeza]

I have problems when i have change of the year