Forum Discussion

ysherriff's avatar
ysherriff
Resolver II
4 years ago

Prior Week Sales

Hi all,

 

I have followed this video from Enterprise DNA, https://youtu.be/jclWnA7pEvY , on how to compute prior week sales. But for some reason my output is not correct. Below is the DAX formula and the output. Thank you for your help.  Also, how can i upload a WIP file? I don't see a link for file upload?

 

 

 

 

Need Help

5 Replies

  • johnt75's avatar
    johnt75
    Super User
    4 years ago

    Add a week commencing column to your date table, like

    [Date] - WEEKDAY([Date],2) + 1

    That starts the week on a Monday, you can adjust if needed. Then change your measure to

    Prior Week = 
var currentWC = SELECTEDVALUE('Date'[W / C])
return CALCULATE( [Total Prospects], REMOVEFILTERS('Date'), 'Date'[W / C] = currentWC - 7)
    • ysherriff's avatar
      ysherriff
      Resolver II
      4 years ago

      Thank you but this is what your formula is showing

       

       

       

      Below is the formula for Week Commencing. 

       

      • johnt75's avatar
        johnt75
        Super User
        4 years ago

        Hmm, it works for me.

        What is the formula for [Total Prospects] ?

        Also, use Performance Analyzer to get the DAX code generated for the table visual, and have a look at that in DAX Studio. See if any additional filters are being applied which would need to be taken care of.

  • johnt75's avatar
    johnt75
    Super User
    4 years ago

    That looks fine.

    Don't think you can upload a file through this site, most people share from Google Drive or Dropbox or similar