Forum Discussion

skaranam's avatar
skaranam
Frequent Visitor
9 years ago
Solved

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,   Currentl...
  • DoubleJ's avatar
    DoubleJ
    9 years ago

    Hi Sai

    How about this one:

     

    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

skaranam's avatar
skaranam
Frequent Visitor
9 years ago

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

DoubleJ's avatar
DoubleJ
Solution Supplier
9 years ago

Hi Sai

How about this one:

 

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