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

DoubleJ's avatar
DoubleJ
Solution Supplier
9 years ago

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

  • 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