Week over Week and comparison this year week to la...

Anonymous · ‎01-28-2020

Hello Everyone

Please help!

I am starting my first PBI project.

But there are some problems.🤔😑

My customers want TABLES with

1. Sales by Week over Week and difference % comparison too /week comparing last week/

2. This year Week sales comparing Last year week sales and difference % as well. /2019.01st week comparing 2018.01st week.../

Are there any methods to show like that? Or it isnt possible to show like that in Power BI?🤔😐🙄😃

🤔😶😑

Anonymous · ‎01-28-2020

Hi @Anonymous

Because there is no sample data I will try to describe the approach I would take.

Here I"m assuming your client wants everything in Table "Matrix"

Sales Week Over Week :

Make New Column of Week Num

WeekNum = WEEKNUM(Table-Date)

Now use this column with revenue/sales data to show sales by week.

Please make sure to change Value -Sales to sum.

2. Calculate Same period last year

SAME PERIOD LAST =

VAR DataMaxDate =

CALCULATE ( MAX ( 'GenIQ'[Date.Date].[Date] ), ALL ('GenIQ' ) )

RETURN

CALCULATE (

[ThisWeekCount],

SAMEPERIODLASTYEAR (

INTERSECT (

VALUES ( 'GenIQ'[Date.Date].[Date] ),

DATESBETWEEN ( 'GenIQ'[Date.Date], BLANK (), DataMaxDate )

)

Regards,

Gaurav Raj Singh

If you need more help,

Week over Week and comparison this year week to last year week