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,
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.