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 a...
Need Help
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.

  • ysherriff's avatar
    ysherriff
    Resolver II
    4 years ago

    The formula for Total Prospects is 

     

    Total Prospects =COUNTA( ( Prospects[Contact ID]))
     
    I will check the performance analyzer. How can i upload a file?