Forum Discussion
Solved
WEEKNUM Relative Date Filtering
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 ...
Hi,
Does this measure work?
Measure = if(ISBLANK(SUM(sold[Quantity Sold])),BLANK(),1-DIVIDE(SUMX(RELATEDTABLE('sold'),[Quantity Sold]),SUMX(RELATEDTABLE('Dispatched'),[Quantity Delivered]),0))
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 :)