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.
Hello All,
I would like to filter my entire report to include all dates(weeknum's) up until the week before current.
E.g. I want my report to include WEEKNUMS 1 through 45 but not week 46 if that was our current week.
I have various graphs which need to report what has sold versus what has been dispatched for the weeks prior to this week.
The reason for weeks is that is the best way to group the data.
Information which may be helpful:
The sold table's Sold Date includes the latest date(& weeknum) which should be used in the report.
Ideally would like it to not be hardcoded and would filter the whole report based on the latest date which something sold.
Or just based on the NOW() time and go back one week as the report will only be relevant for that week until new data is imported.
This is only my second post here so please let me know if you need any more information to help me out.
Thank you
Solved! Go to Solution.
Hi,
Does this measure work?
Hi,
Share the link from where i can download your PBI file.
Hi,
Appreciate the offer - However, unfortunately, there is some sensitive data in the report.
Is there an easy way to anonymize/de-sensitize or limit your access to this data?
Further, how would you recommend I upload the file for you to download it?
Hi,
Create a dummy dataset and upload the file to Google Drive or any such similar service. Share the download link.
Hi,
I get the "Access denied" message when i click on that link.
Hi,
I changed the link to private last night as I assumed you would have already downloaded it - public again now 🙂
Hi,
In the Stores Table, there is no Date column. There should be a Date column there which should connect to the dateKey Table.
The Stores table is just a list of supermarkets - I don't believe a date column would work as a store does not have a date?
Hi,
Does this measure work?
Hi,
Yes, that works! So just to make sure I understand the DAX:
This checks if the quantity sold sum is blank - if so then then use blank as the data, otherwise use the correct data and graph it?
Good to know that. Yes, that is correct.
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |