Forum Discussion
NiugeS
Helper V
Helper VMeasure - Filter with relative date
Hi all,
I'm a bit stuck (and still learning BI) but I have a column 'Items' that includes a description of 'Highest'. I have been able to create a measure that gives me a total of 'Highest' as per below.
KeyCount for High Priority = CALCULATE( [KeyCount], 'Items'[Priority] = "Highest")
I am now trying to add a measure on the same column but provide me with a total of 'Highest' but only where the 'Created' date is within the past 6 months.
I can do it using the visuals on the filter but stuck on the measure.
Any guidance appreciated.
I can do it using the visuals on the filter but stuck on the measure.
Any guidance appreciated.
NiugeS , Try a measure like
KeyCount for High Priority = CALCULATE( [KeyCount], filter('Items', 'Items'[Priority] = "Highest" && 'Items'[created Date] >= eomonth(today(),-7) + 1 && 'Items'[created Date] <=today()))
2 Replies
- amitchandak
Super User
NiugeS , Try a measure like
KeyCount for High Priority = CALCULATE( [KeyCount], filter('Items', 'Items'[Priority] = "Highest" && 'Items'[created Date] >= eomonth(today(),-7) + 1 && 'Items'[created Date] <=today())) 
NiugeSamitchandak Thank you! That worked. Can I ask why eomonth(today(),-7)+1 and not simply eomonth(today(),-6)?