Forum Discussion

Dev_B_PBIing's avatar
Dev_B_PBIing
Frequent Visitor
3 years ago

Measure to exclude current quarter

Hello, I'm working with data that, due to the sensitivity, I need to exclude the fiscal quarter in progress.  I want this to be something that happens automatically so I don't need to update the filter each quarter.  Is there a way to easily do this either through a measure or through power query?  I have my data on one table and my dating on another with relationships.

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    Dev_B_PBIing , a measure before this Qtr

     

    This Qtr Today =
    var _today = today()
    var _max = eomonth(_today, if( mod(Month(_today),3) =0,0,3-mod(Month(_today),3)))
    var _min = eomonth(_max,-3)+1
    return
    CALCULATE([Net], FILTER('Date','Date'[Date] <_min ))

     

    Where net is my measure