Forum Discussion

NiugeS's avatar
NiugeS
Helper V
5 years ago
Solved

Measure - 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 pe...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    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()))

NiugeS's avatar
NiugeS
Helper V
5 years ago

amitchandak Thank you!  That worked.  Can I ask why eomonth(today(),-7)+1 and not simply eomonth(today(),-6)?