Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
HI all,
I am looking to do 2 different measures which gives me the following: -
- for each date, I want to see the last 7 days of sales
- for each date, I want to see the last 30 days of sales
Example: - Today, I want to see that yesterdays date contains the count of sales for (22nd, 21st, 20th, 19th, 18th, 17th & 16th) which would then mean that 21st date would contact count of sales from 21st - 15th) - Of course the other measure should be doable by amending this one.
In my table,
Hope that makes sense.
Solved! Go to Solution.
You can mark it as answer by clicking below option:
@TheLegendTamer
Can you share some sample data and the expected result to have a clear understanding of your question?
You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.
____________________________________
How to paste sample data with your question?
How to get your questions answered quickly?
_____________________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Thanks for your reply.
The below is what I am hoping for - dont have any sample data yet im afraid.
3 measures in total - yesterday which is fine. Then last 7 days and last 30 days. So looking at yesterdays date on the 'x' axis it gives sum of sales from yesterday, last 7 days from yesterday and last 30 days from yesterday.
you can use something like
Proud to be a Super User!
Diamond! Thank you muchly
If the above posts help, please kindly mark it as a answer to help others find it more quickly. thanks!
If not, please kindly elaborate more.
I have marked it as a thumbs up, doesnt this mean its the answer?
You can mark it as answer by clicking below option:
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
122 | |
101 | |
71 | |
61 |