Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
That looks fine.
Don't think you can upload a file through this site, most people share from Google Drive or Dropbox or similar
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)
Thank you but this is what your formula is showing
Below is the formula for Week Commencing.
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.
The formula for Total Prospects is
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
100 | |
76 | |
68 | |
62 |
User | Count |
---|---|
142 | |
106 | |
103 | |
85 | |
70 |