cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

## Week over Week calculations - Previous Week Calculations - Power BI

Hello All,

I am working on a power bi report and i have bugsfound for each week. I need to get previousweeknumber and then its bugs so that i can calculate WoW. Below is the summary,

Currently i have this

WeekNbr        BugsFound

34                       10

35                       20

36                       30

With formula in power bi, i calculated PrevWeekNbr

WeekNbr        BugsFound        PrevWeekNbr

34                       10                           33

35                       20                           34

36                       30                           35

What i need is (imagine week 33 bugs are 5)

WeekNbr        BugsFound        PrevWeekNbr   PrevWeekBugs

34                       10                           33                    5

35                       20                           34                   10

36                       30                           35                   20

I tried different formulas for new measure but did not get lucky. Any ideas ??

1 ACCEPTED SOLUTION

Accepted Solutions
Member

## Re: Week over Week calculations - Previous Week Calculations - Power BI

Hi Sai

`PrevWeeksBugs2 = LOOKUPVALUE(Bugs[BugsFound];Bugs[WeekNbr];Bugs[PrevWeekNbr])+0`

It is not a very nice solution I admit, someone might provide a better one.

JJ

3 REPLIES 3
Member

## Re: Week over Week calculations - Previous Week Calculations - Power BI

Hi

Creating a colmn with this forumla might help (you might have to replace the semicolons with commas):

```PrevWeekBugs =
SUMX(
FILTER(
Bugs;
Bugs[WeekNbr] = EARLIER(Bugs[PrevWeekNbr])
)
;Bugs[BugsFound]
)+0```

Hope this helps

JJ

Frequent Visitor

## Re: Week over Week calculations - Previous Week Calculations - Power BI

Hello JJ,

Thanks for your quick response and solution

I am using directquery models and i think thats the reason i am getting below error while using below logic.

Function 'SUMX' is not allowed as part of calculated column DAX expressions on DirectQuery models.

Any ideas on this.

Thanks,

Sai

Member

## Re: Week over Week calculations - Previous Week Calculations - Power BI

Hi Sai

`PrevWeeksBugs2 = LOOKUPVALUE(Bugs[BugsFound];Bugs[WeekNbr];Bugs[PrevWeekNbr])+0`

It is not a very nice solution I admit, someone might provide a better one.

JJ

Announcements

Kudos to you if you earned one of these! Check your inbox for a notification.

#### Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

#### Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (2,942)