Skip to main content
cancel
Showing results for
Search instead for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

## Difference between two values by Week

Hey guys,

I hope all is well!

I'm looking for a DAX command that can produce the below results.

I have a series of weeks (not dates) that need to show a count up or down and ideally a percentage increase/decrease but I'm strugging to put this into Power BI

 Week Count Result Increase/Decrease Week 45 5 Week 46 6 1 20% Week 47 1 -5 -83.33% Week 48 7 6 600%

Is someone able to support with this?

Thanks!

Steve

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi!

This here might work, using a similar function as the Lag function

All the best,

Pétur

4 REPLIES 4
Super User
Anonymous
Not applicable
``````// That's pretty easy in fact if you have the
// right structure. The table that stores
// weeks must have a column that is a contiguous
// sequence of integers. Let's name the column
// WeekID. Normally, such a column would be hidden
// as it's just a key for the weeks to make them
// distinguishable from each other. This table
// will be connected to some fact table with
// measures.

[Week-by-Week Delta] =
IF(
// When we calculate the delta,
// we have to make sure that
// only one week is visible in
// the current context.
HASONEVALUE( Weeks[WeekID] ),

var __currentWeekId = SELECTEDVALUE( Weeks[WeekID] )
var __currentValue = [CountResult]
var __priorValue =
CALCULATE(
// This is the base measure
// of which you want to calculate
// the delta.
[CountResult],
Weeks[WeekID] = __currentWeek - 1
)
var __delta = __currentValue - __priorValue
return
__delta
)

[Increase/Decrease] = DIVIDE( [Week-by-Week Delta], [CountResult] )``````

You might need to adjust the measure to deal with boundary conditions. Simply test it and fix the places where it goes astray.

Best

D

Anonymous
Not applicable

Hi!

This here might work, using a similar function as the Lag function

All the best,

Pétur

Anonymous
Not applicable

Worked perfectly !

Thanks all 🙂

## Helpful resources

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Join our Community Sticker Challenge

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

#### Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

#### Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors