Week Over Week Change for Scorecards

[gelkins81]

Hi everyone!

New to the forums and looking for some help.

I'm trying to have a WoW percent change scorecard underneath the main KPI scorecard, but having an issue with it returning the total result instead of the individual row result.  Here is an example screenshot:

Ignore the (Blank).  Those are from a previous build where I was doing MoM using Parallelperiod, which works great.  Unfortunately Parallelperiod doesn't, currently, support Weeks so this is not an option, to my knowledge.

As for my calculations:

Year Week =

VAR _YearCurrentRow = YEAR(Oneview[Date])

VAR _MonthCurrentRow = MONTH(Oneview[Date])

VAR _WeekCurrentRow = WEEKNUM(Oneview[Date],21)

VAR _YearReturn = IF(_WeekCurrentRow > 50 && _MonthCurrentRow = 1, _YearCurrentRow - 1, _YearCurrentRow)

RETURN

_YearReturn * 100 + _WeekCurrentRow

Oneview_Previous_Week_Impression = CALCULATE(SUM(Oneview[Oneview_Impressions]),OFFSET(-1,,ORDERBY('Oneview'[Year Week])))

Oneview_Previous_Week_Percent_Impressions = CALCULATE(DIVIDE(SUM(Oneview[Oneview_Impressions])-[Oneview_Previous_Week_Impression],[Oneview_Previous_Week_Impression],0))

Any ideas from anyone?

Thanks in advance!

[bhanu_gautam]

@gelkins81 Calculate the Previous Week Impressions:

Oneview_Previous_Week_Impression =
CALCULATE(
SUM(Oneview[Oneview_Impressions]),
FILTER(
Oneview,
Oneview[YearWeek] = EARLIER(Oneview[YearWeek]) - 1
)
)

Calculate the WoW Percent Change:

Oneview_Previous_Week_Percent_Impressions =
DIVIDE(
SUM(Oneview[Oneview_Impressions]) - [Oneview_Previous_Week_Impression],
[Oneview_Previous_Week_Impression],
0
)

[gelkins81]

Thanks for such a quick response!

I did try this solution, but am getting an error with the Earlier function:

Thoughts?  Sorry, I am somewhat new to Dax as I used Tableau at my previous agency and where I am now uses PowerBi.  I've learned a lot over the past 6 months, but there's a lot of different functions that I just don't know about yet.  Thanks!

[bhanu_gautam]

Use DATE ADD instead of earlier 

dax
Oneview_Previous_Week_Impression =
CALCULATE(
SUM(Oneview[Oneview_Impressions]),
DATEADD(Oneview[Date], -7, DAY)
)

[gelkins81]

This is outputting the wrong amount:

When I don't have the filter, the table outputs the correct amount on the row, but not at the total.  I need to figure out a way to output the row amount and not the total.

[Anonymous]

Hi, @gelkins81 

Can you provide some of the sample data and what you expect the output to be? Please remove any sensitive data in advance. How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.